Nick Anderson wrote:
I have a document that has multiple pivot tables. All pivots need to be
resourced to the same table within access. Is there a way to do this without
having to resource each table individually?

Thanks
Nick

Create the first PT (using all the column you will need now and later)
on a new worksheet.

Copy the PT, or the entire PT worksheet to a new worksheet, and change
the new PT as needed.

Rinse and repeat.

Mike Alexander recently discussed this he
http://datapigtechnologies.com/blog/...books-in-half/