How can you NOT grant only display rights to a specific user in the Microsoft Excel UI?

Assigning roles in the SAP backend system is not a method for granting only display rights to a specific user in the Microsoft Excel user interface. While roles play a fundamental part in defining user permissions and access rights within SAP systems, they primarily operate at a higher level, influencing what users can access across the entire SAP environment rather than offering specific controls within the Excel UI.

The options that allow you to limit access within the Excel add-in focus specifically on controls that can be applied to the Excel interface without needing changes at the backend system. User preferences would allow individuals to set their display options, filters in the Administration Console help manage broader access settings, and value-based filters can be set in the Excel add-in to restrict data visibility for that user on a specific workbook level. These are more suited to managing the way data is visualized and accessed when using Excel for SAP IBP directly.

In summary, the assignment of roles in the SAP backend does not provide the granularity needed to give display-only access within the Microsoft Excel UI, making this option distinct from the others that directly manipulate visibility and access levels within the Excel interface.