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.

 

[Smitty]

If you record a macro refreshing all of your data in the sequence you want you can then assign that to a button.

HTH,

Smitty