2689020 - The structure of the crosstab is remained when open a workbook with "Remove Data Before Saving" selected

The structure of the crosstab is remained, non data areas (header areas) are displayed as grey, all data cells were merged to one single data cell which contains the text "Data removed. Refresh to update data display".

Before Saving:

After Saving:

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Analysis for Microsoft Office 2.7
• SAP Analysis for Microsoft Office 2.8

Open a workbook with "Remove Data Before Saving" selected.

This behaviour is by design.

When the workbook was saved with "Remove Data Before Saving", AO kept the main structure of the crosstab visible. All data cells were merged to one single data cell which contains the text "Data removed. Refresh to update data display". The non data areas (header areas) were displayed with a special style 'SAPDataRemoved'. This style is by default grey and you can change this style as per Chapter "Defining style sets for crosstabs" in the User Guide of Analysis Office, available in https://help.sap.com/boao.

 AO, Analysis for Excel, Analysis for Office, A4O, style, color, format, layout , KBA , BI-RA-AO-XLA , Excel Addin , Problem

SAP Analysis for Microsoft Office 2.7 ; SAP Analysis for Microsoft Office 2.8