Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refreshing Pivot Tables
I am working in Excel 2003 in a workbook created by someone else (and I have
little experience with Pivot Tables). This workbook has multiple pivot tables in multiple worksheets, all based off the same source data. Each time you refresh one Pivot Table it refreshes all Pivot Tables. Is there any way to break that link so that I can just refresh some of the tables? Thanks, in advance, Holly |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refreshing Pivot Tables
Hi Holly
If you right click on the PT, choose Pivot Table WizardBack it will show you where the source range is located. Make a note of the range (or table name if applicable). Now, create a named range for the same location with InsertNameDefine Name MyTbl Refers to The same range as you noted above. Now, back to the PTright click.PT wizardBack and enter in source = MyTbl Although the PT is pointing at the same data, it is not using a "common source" so that PT will be refreshed independently of others. -- Regards Roger Govier "hnyb1" wrote in message ... I am working in Excel 2003 in a workbook created by someone else (and I have little experience with Pivot Tables). This workbook has multiple pivot tables in multiple worksheets, all based off the same source data. Each time you refresh one Pivot Table it refreshes all Pivot Tables. Is there any way to break that link so that I can just refresh some of the tables? Thanks, in advance, Holly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables | Excel Worksheet Functions | |||
refreshing pivot tables with a macro | Excel Discussion (Misc queries) | |||
pivot tables not refreshing correctly | Excel Worksheet Functions | |||
Pivot Tables are Automatically refreshing | Excel Discussion (Misc queries) |