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;
  • Make sure the option "Refresh Workbook on Opening" is unchecked:

    Refresh Workbook on opening.png

 

See Also

User's Guide of Analysis, edition for MS Office available in http://help.sap.com/boao

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