Button to Refresh to All Pivot Tables

Hey guys.. is there a way you can custommize a button to refresh all the pivot tables with one button in excel ?? Thanks

Create a button and then assign this macro to it...it should do the trick.

Please Login or Register  to view this content.

Hope that helps.

Originally Posted by Claymation

Create a button and then assign this macro to it...it should do the trick.

Please Login or Register  to view this content.

Hope that helps.

Another way: go to Tools - Customize, and somewhere ( haven't got XL here) there is a button you can add to your toolbar called
" refresh all"
HTH

awesoem... thanks guys! the second option was much simpler and worked!