3042970 - Analysis Office unresponsive Buttons when using multiple monitors

Symptom

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

Environment

SAP Analysis for Microsoft Office all versions

Cause

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

Resolution

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:

Keywords

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

Product