PivotTable Filter Update

[yonyon7]

Hi,

Is there a way to postpone PivotTable update until after filer update?

Please Login or Register  to view this content.

Adding the ManualUpdate (

Please Login or Register  to view this content.

) property doesn’t seem to help. Whenever an item is marked or unmarked the PivotTable updates the spreadsheet. (

Please Login or Register  to view this content.

doesn’t seem to do the work either)

Any ideas?

Thanks,
yonyon

[yonyon7]

seems like

Please Login or Register  to view this content.

works.. not that great but better than nothing..