|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
Asked by HSdba in Microsoft Excel Spreadsheet Software, Visual Basic Programming
I have a workbook with a spreadsheet whose Worksheet_Activate event performs a PivotCache.Refresh on a Pivot Table. I notice when I make a copy of the spreadsheet the active sheet event appears to refresh the pivot table in the orginal and copy even though the reference is for only the active sheet. I'm assuming this is occuring because the Source Data for each Spreadsheet Pivot Table is the same.
Is it possible to refresh Only the active sheet pivot table ?
20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625
