Have you ever had someone sent you a PowerPivot model and asked you to do something with it? And if so – may be, you would have to see what data source(s) the model is using and if applicable, you test the existing connections. If you find yourselves in such a situation, this blog post is for you:
1) Open the excel file and switch to PowerPivot Window
2) Now, switch to Design Tab > Click on Existing Connections:
3) Here you’ll find the list of connections under “PowerPivot Data Connections” > Select the connection you wish to TEST or EDIT > Click on EDIT button
4) Now here you can edit the data source. And if you click on “Test Connection”, you’ll be able to test it too.
5) After you’re done, click on SAVE.
And you’ll now see the “Existing Connections” Box again:
Click CLOSE and you’re done, you have successfully edited or tested the existing connection.
- PowerPivot Model: Why am I not seeing “Month Names” in correct logical order? (parasdoshi.com)
- What’s the benefit of columnar databases? (parasdoshi.com)
- Excel file does not open, Its stuck indefinitely in “opening in protected view” stage (parasdoshi.com)