SAP Knowledge Base Article - Preview

2670331 - Analysis Office Compatibility issues after Excel 2016 update


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:

  1. Blank/empty Design Panel;
  2. Empty filter dialog;
  3. Empty message dialog;
  4. Clicking on the [+] or [-] symbols of a hierarchy do not work;

Below are some screenshots, showing the Design Panel and Filter Dialog empty:

Empty panel.png    Filter empty.png



Microsoft Excel 2016

Microsoft Excel 2019 

SAP BusinessObjects Analysis, edition for Microsoft Office


SAP Analysis for Microsoft Office all versions ; SAP BusinessObjects Business Intelligence platform 4.2


Analysis Office, Excel, compatibility, stability, freeze, blank, hang, Office 365, filter, empty, control, panel, 1806, list of members, overlap, field, message , KBA , not select anything , filter by member prompts / dialogue were , appearing empty and he could not select , 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 page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.