SAP Knowledge Base Article - Public

2542454 - How to replace/change the data source in the existing Analysis Office workbook


It is necessary more information about how to replace a data source in the existing workbook.


SAP Analysis for Microsoft Office


  1. Open the existing workbook in Analysis Office;
  2. Go to the Design Panel (in case it is not visible, click on "Display" > "Display Design Panel");
  3. Click on tab "Components";
  4. Select the data source;
  5. Click on the pencil besides "Data Source Name".
    Change data source option.png
  6. Select the system and the new data source.

Note: the data source will be inserted with its initial navigational state. Selecting the same data source will also reset the navigational state (e.g. previous filters, drilldowns, etc).

See Also

Chapter "The Components tab" in User Guide of AO.


replace, data source, query, change, reset, lost, change datasource, change data source, data source Alias, datasource alias , KBA , BI-RA-AO-XLA , Excel Addin , How To


SAP Analysis for Microsoft Office all versions