SAP Knowledge Base Article - Public

2211687 - "Replace System" button is greyed out / disabled

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

Replace Button disabled.png

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:

        2024-03-14_09-49-27.png

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):

       EditorOverview.jpg

See Also

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

Product

SAP Analysis for Microsoft Office all versions