Macro to Show/Select All in Pivot

[Sun2620]

Hi I need to write a macro with a reset button that will go through the Pivot and refresh all fields one by one and click the (Select All) option to show all the items within each Row Fields and Column Fields. When I record the Macro it goes through and turns on all items within a field one by one by naming each item within a field and making it Visible and that's too slow. there is no way to make it more dynamic and faster, so as to just check the (Select All) box ON for each field?

Thanks

 

[Fazza]

Hi, Please set the PT's ManualUpdate property to false, make the changes, then reset ManualUpdate to true. HTH, F

 

[Sun2620]

Hi, Please set the PT's ManualUpdate property to false, make the changes, then reset ManualUpdate to true. HTH, F

Thanks, I'm still not sure how to go about and check the box in each pivot field that's called (Select ALL) in the macro. Any help with that would be great.
Thanks

 

[Fazza]

Searching for 'manualupdate" will find a few threads.

Such as http://www.mrexcel.com/forum/showthread.php?t=363661

Pls modify to suit