PivotTable Filter Update

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