SAP Knowledge Base Article - Public

3042970 - Analysis Office unresponsive Buttons when using multiple monitors


Some buttons in Analysis Office are not working or are unresponsive when using multiple monitors.


SAP Analysis for Microsoft Office all versions


Excel has option "Optimize for best appearance" instead of "Optimize for compatibility" under User Interface Options.


We have to change to compatibility under the following path:

Go to menu "File" -> Click on "Options" -> check if in "General" tab, under "User Interface Options", if you have the option "Optimize for best appearance" or "Optimize for compatibility".

If the first one is ticked, please change to "Optimize for compatibility", close your AO, open again and test the same buttons.

See picture below to confirm the place for it:

See Also

2975028 - Analysis for Office Unresponsive Buttons


unresponsive, button, optimize, compatibility, appearance, button not working , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions