SAP Knowledge Base Article - Preview

2670331 - Analysis Office Compatibility issues after Excel 2016 update

Symptom

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. Filter dialog empty;
  3. 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


Read more...

Environment

Microsoft Excel 2016

Microsoft Excel 2019 

SAP BusinessObjects Analysis, edition for Microsoft Office

Product

SAP Analysis 1.0, edition for Microsoft Office ; SAP Analysis for Microsoft Office 2.6 ; SAP Analysis for Microsoft Office 2.7 ; SAP Analysis for Microsoft Office 2.8 ; SAP BusinessObjects Analysis 1.1, edition for Microsoft Office ; SAP BusinessObjects Analysis 1.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 1.3, edition for Microsoft Office ; SAP BusinessObjects Analysis 1.3, edition for Microsoft Office, evaluation version ; SAP BusinessObjects Analysis 1.4, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.0, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.1, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.3, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office ; SAP BusinessObjects Analysis for Microsoft Office 2.5 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

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 page

This 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.