Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivit table- cell on spread sheet referencing pivot table field David M Charts and Charting in Excel 2 August 18th 07 07:46 PM
can entered data in sheet 1 be automatically pasted in sheet 2 Adnan Jahangir Excel Discussion (Misc queries) 1 February 23rd 06 11:06 AM
Help! data from pasted table is not included in sum campli Excel Worksheet Functions 5 January 12th 06 09:54 PM
HTML Table pasted to Excel Josh O. Excel Discussion (Misc queries) 2 October 19th 05 06:52 PM
Why won't pasted values from a formula appear in a pivot table B_4j Excel Discussion (Misc queries) 1 June 24th 05 06:53 PM


All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"