I followed those steps:
To change the external data source used by a current connection
1.In the PowerPivot window, click the Home tab, and in the Connections group, click Existing Connections.
2.Select the current database connection and click Edit.
For this example, the Table Import Wizard opens to the page that configures an Access database. However, depending on the type of data source you are changing, the provider might be different, and also the properties that are available.
3.In the Edit Connection dialog box, click Browse to locate another database of the same type but with a different name or location.
As soon as you change the database file, a message appears indicating that you need to save and refresh the tables in order to see the new data.
4.Click Save, and then click Close.
5.On the Home tab, in the Get External Data group, click Refresh, and then click Refresh All.
The tables are refreshed using the new data source, but with the original data selections.
However always get the error attached in excel file
Can you help me?
Thanks in advanced
- Error message when I change source.xlsx
- (540.21 KiB) Downloaded 136 times