Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasted Pivot Table looks at old sheet
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasted Pivot Table looks at old sheet
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 PTPT Wizardbacksource change source to point at the range of data you want to be used for that PT. -- Regards Roger Govier "DawnTreader" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) | |||
Help! data from pasted table is not included in sum | Excel Worksheet Functions | |||
HTML Table pasted to Excel | Excel Discussion (Misc queries) | |||
Why won't pasted values from a formula appear in a pivot table | Excel Discussion (Misc queries) |