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?