How to change a pivot table data source

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi,

Excel 2000 and Access 2000

Is it possible to change the data source of an existing pivot table?

I have a database in access which is put on to a CD monthly with a Excel
pivot table, however when created, the CD is generated with the data source
being on drive D and lots of my team that use this pivot table, have CD
drives as either E or F and as such when they add data items to the pivot
table its not updated.

Appreciate your help,

Rob
 
Sure. With the pivot table selected, right click and select wizard, then
hit the back arrow and change the source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Pivot table 1
Pivot Table Help! 1
Pivot table report invalid 0
making an excel table visible for external data on pivot table 1
Pivot Table Source file 2
Turning Data into a Table 1
How to base a pivot table on another pivot table? 3
pivot table loosing decimals (vba) 1

Back
Top