After upgrading Excel to version 1806 or higher, Analysis Office (or other SAP add-ins) can no longer display some controls in dialog boxes and task panes. If you revert Office to version 1805, this issue doesn't occur.
Some examples are:
- Blank/empty Design Panel;
- Filter dialog empty;
- Clicking on the [+] or [-] symbols of a hierarchy do not work
Below are some screenshots, showing the Design Panel and Filter Dialog empty:
Microsoft Excel 2016
Microsoft Excel 2019
SAP BusinessObjects Analysis, edition for Microsoft Office
Analysis Office, Excel, compatibility, stability, freeze, blank, hang, Office 365, filter, empty, control, panel, 1806, list of members, overlap, field, , KBA , filter by member prompts / dialogue were , appearing empty and he could not select , not select anything , excel setting: optimize for compatibili , compatibility , ao aoff a-o , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-WB , Queries in Workbooks , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.