Reporting - Change source from AFO workbook

https://visualbi.com/blogs/sap/analysis-for-office/replace-system-analysis-for-office-workbook/

Procedure to Replace the system:

1. Logging off from a system:

Firstly, you will have to log off from the system to which the workbook is currently connected.

To disconnect a workbook from the server (BW or HANA), perform the following step.

Go to Display Panel -> Components Tab -> Right Click on Workbook name -> Log Off

In the Replace System dialog box, you can select the system that you want replaced (Current System) and the system that you want the current system to be replaced with (Replace by System).