views:

9896

answers:

6

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

+1  A: 

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

adolf garlic
A: 
  • 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'
Bravax
This does not work. There is no getdata button on the 'choose external data source' page of the wizard. And if you do click 'get data' on the next page, there is no immediately obvious way of editing the connection
adolf garlic
Amended, see the last point.
Bravax
+1  A: 

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).

A: 

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.

ryan
A: 

How do I solve this problem in Excel 2007

Kumaran
+1  A: 

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.

Zoe