move existing pivot tables sheet to new workbook

[Marckas]

I have a number of pivot table sheets feeding of a query. I have created a new field in the query and created a new pivot table worksheet. Now I want to move the old existing sheets to the new one. When I move them to the new workbook, I noticed it still feeding of from the old query. Is there any way I could change the data source or do I have to recreate all the existing pivot table sheets.

 

[SkipVought]

Hi,

This does not appear to be a Microsoft Access question; rather EXCEL. Fi so and if this does not answer your question, please repost in Forum68.

Open the PT Wizard.

Hit the BACK key and then change the Source Data Reference.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}