Thisworkbook.refreshall
--
HTH...

Jim Thomlinson


"Cam" wrote:

Hello,

What is the VB code for a macro to refresh data from all pivot tables?
I would like the macro to update the data on all the sheets. Thanks