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

It is required to replace the system in an existing Analysis for Office workbook.

On File > Analysis > Settings >  Platform Settings, the button "Replace System" is greyed out (i.e. disabled).

"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

1.     Open an Analysis for Office workbook
2.     Go to File > Analysis > Settings >  Platform Settings
3.     Observe the the button "Replace System" is grey

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.

Make sure that the workbook is not connected to any system before trying to replace the systems.

1. Do not refresh the data sources;
2. 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:

1. Right click in the [WorkbookName] > Log Off option (1) 
2. Right click in the [WorkbookName] again > Replace System (2):

• Relevant section in SAP Help
• KBA 2448743 - How to replace the system of an existing Analysis Office workbook

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