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.
 
Back
Top