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.
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.