Pasted Pivot Table looks at old sheet

[DawnTreader]

Hello all

i have a quick question about pivot table pasting. i have a workbook where i
am copying the sheet and making a new version for the next month. each time i
do the pivot table on the new month sheet is looking at the old month sheet.
the pivot table is on the same sheet where the data is that it looks at so
each time i copy i want the new sheet to be totaly autonomous from the last
month sheet.

why does the pivot table not update to look at the new sheet?

 

[Roger Govier]

Hi

Copying a Pivot Table will just make the PT use the same source data for
it's Pivot Cache
Right click on a cell in the PT>PT Wizard>back>source >change source to
point at the range of data you want to be used for that PT.

--
Regards
Roger Govier

Hello all

i have a quick question about pivot table pasting. i have a workbook where
i
am copying the sheet and making a new version for the next month. each
time i
do the pivot table on the new month sheet is looking at the old month
sheet.
the pivot table is on the same sheet where the data is that it looks at so
each time i copy i want the new sheet to be totaly autonomous from the
last
month sheet.

why does the pivot table not update to look at the new sheet?

__________ Information from ESET Smart Security, version of virus
signature database 4752 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4752 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com