Hi Guys,
I currently us the tiny script:
To refresh all my Powerpivot tables in a Workbook. How would I go about writing a script that would just refresh selected tables? Ideally I would like to refresh two separate groups of tables with two separate macros.
Not having much luck finding an answer to this!
Thanks for any help.
Plex.
I currently us the tiny script:
Code:
Public Sub UpdateAllPVT()
ActiveWorkbook.RefreshAll
End Sub
To refresh all my Powerpivot tables in a Workbook. How would I go about writing a script that would just refresh selected tables? Ideally I would like to refresh two separate groups of tables with two separate macros.
Not having much luck finding an answer to this!
Thanks for any help.
Plex.