vba_monkey
Board Regular
- Joined
- Dec 18, 2013
- Messages
- 112
Hello,
This code will aloow me to defer pivot table updates on a single table:
I have six pivot tables on various sheets and I want to make changes to all of them first before refreshing all in one go. Is there simple way, without using a loop, to set all pivot tables to manual at the same time. As in, a single line, like the above?
Thanks
This code will aloow me to defer pivot table updates on a single table:
VBA Code:
Worksheets(1).PivotTables("Pivot1").ManualUpdate = True
I have six pivot tables on various sheets and I want to make changes to all of them first before refreshing all in one go. Is there simple way, without using a loop, to set all pivot tables to manual at the same time. As in, a single line, like the above?
Thanks
Last edited by a moderator: