3414192 - The option "Remove Data Before Saving" is disabled in the Design Panel of Analysis for Office

Symptom

The option "Remove Data Before Saving" is disabled in the Design Panel of Analysis for Office.

Option disabled.png

Environment

SAP Analysis for Microsoft Office

Cause

The configuratino level of the setting RemoveDataBeforeSaving was changed from UserRoaming to PerMachine in Ao_app.config file.

Resolution

This is not a bug in the tool. If the configuration level of setting RemoveDataBeforeSaving is PerMachine in Ao_app.config file, then the option "Remove Data Before Saving" is disabled in the Design Panel of Analysis Office.

Refer to documentation below:

SAP Note 3288963 - Increase Setting's Level via Configuration File
Chapter "Supported BI Platforms"
Chapter "To save a workbook"
Chapter "RemoveDataBeforeSaving"

Keywords

grayed out , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions