How to change a pivot table data source

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
 
T

Tom Ogilvy

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