How to change pivot table data source in Excel?

Question

I want to change it from one database to another.

There don't appear to be any options to do this on the pivot table context menu

Answer 1

right click on the pivot table in excel choose wizard click 'back' click 'get data...' in the query window File - Table Definition

then you can create a new or choose a different connection

Answer 2

• Right click on the pivot table, choose PivotTable Wizard.
• Click the 'back' button twice.
• Choose External Data Source,click next.
• Click Get Data
• In the first tab, Databases the first option is 'New Data Source'

Answer 3

This Add-on will do the trick for you.

http://www.contextures.com/xlPivotPlayPlus01.html

It shows the connection string, and allows it to be changed. Don't forget to change the Query SQL as well, if needed (with the same tool).

Answer 4

right click on the pivot table in excel choose wizard click 'back' click 'get data...' in the query window File - Table Definition

then you can create a new or choose a different connection

worked perfectly.

the get data button is next to the tiny button with a red arrow next to the range text input box.

Answer 5

How do I solve this problem in Excel 2007

Answer 6

Just figured it out-click anywhere in the table, then go to the tabs at the top of the page and select Options-from there you'll see a Change Data Source selection.