Symptom
It is currently not possible to change Data Source in existing SAC Excel Add-in workbooks.
Environment
SAP Analytics Cloud, add-in for Microsoft Office
Cause
This is expected behavior.
For more information on how source system replacement works, refer to the SAP Help documentation: Analyzing Data > Sign Out
Resolution
This behavior is expected and reflects the current product design.
You can also replace the current tenant to run a workbook on a new tenant. To make the workbook run properly after the replacement, make sure that all data sources and connections used in the workbook, are available on the new tenant.
We are aware that some customers would like this behavior to change. A related idea has been submitted on the SAP Influence portal: https://influence.sap.com/sap/ino/#/idea/315054.
You are welcome to vote on this idea to express your interest in future change.
Keywords
tenant, data source, replacement, excel, add-in, workbook, report , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem
SAP Knowledge Base Article - Public