Refresh all pivots

J

Jenn

Is there a command that allows me to refresh all the pivot tables in my workbook. I have about 5 and don't want to refresh 1 by 1.
Thanks in advance!
 
F

Frank Kabel

Hi
use the following macro:
sub refresh_it()
activeworkbook.refreshall
end sub
 
D

Debra Dalgleish

Open the External Data toolbar (View>Toolbars>External Data)
Click the Refresh All button
 
Top