Symptom
It is required to replace the system in an existing workbook of Analysis for Office.
On File > Analysis > Settings > Platform Settings, the button "Replace System" is greyed out (i.e. disabled).
Environment
SAP Analysis for Microsoft Office
Cause
The "Replace System..." button to open the dialog is enabled only if a workbook with a data source is opened but not yet connected to any of the systems.
Resolution
Make sure that the workbook is not connected to any system before trying to replace the systems.
- Do not refresh the data sources;
- Go to Design Panel > Display > Components tab > Make sure the option "Refresh Workbook on Opening" is unchecked:
However, if you are already connected, you can also try this:
- Right click in the [WorkbookName] > Log Off option (1) > Right click in the [WorkbookName] again > Replace System (2):
See Also
- SAP Help - Platform Options - Replace System
- SAP KBA - 2448743 - How to replace the system of an existing Analysis Office workbook
Keywords
Analysis for MS Office, AO, replace, system replacement, replace system, greyed out, disabled, grayed out, change, connection, local, connection, workbook, existing , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , How To