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 |
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 |
All times are GMT +1. The time now is 12:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com