Refresh All

[jpiazza]

I have a workbook that has multiple worksheets.
Some worksheets have XML data that is imported, some have pivot tables.
I would like to be able to "Refresh All" external data sources first , then update the pivot tables.

Is there some easy way to do this ? i.e. a snipet of VBA code on a "Refresh All Button" ?

Thanks in advance.

 

[tusharm]

Duplicate: http://www.mrexcel.com/board2/viewtopic.php?t=238770

 

[jpiazza]

This link appears to take me back to my post ?