How to change the database for your PowerPivot sheet.

As of Office 2010, you can use PowerPivot in combination with Excel. The PowerPivot is a very powerfull tool to analyze the data in your database. After having build some nice pivots on one of your databases, it can happen that you want to re-use the same sheet on a different database.

In this blog I will explain how you can update your PowerPivot sheet with data from a different database.

• Open your Excell sheet.
• Select the PowerPivot ribbon tab.

• Select the PowerPivot Window button in the ribbon. The PowerPivot window is now started.
• Select the design tab.
• Select button: Existing Connections.

• Select your PowerPivot data connection.

• Press edit button.
• Change the server and or database you want to use.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

• Press the 'test connection' button to see if you can connect to the database.
• Press save.
• Press Close
• Select the Home tab in the PowerPivot ribbon.

• Select Refresh all button. Now the data refresh window is displayed.

 

• Press Close when data is updated successfully.

Now we need to update the excell sheet with the data in the power pivot sheet.
 

• Go back to your excell sheet.
• Select the Data tab in the ribbon.
• Select the refresh all button.

Now all data in your excell sheet is updated with the data of the selected database.
Enjoy analyzing your data with the PowerPivot.