VBA/Powerpivot

[Plexus]

Hi Guys,

I currently us the tiny script:

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.

Tried this question in the general Excel forum but no replies.

Thanks for any help.

Plex.

 

[Plexus]

Anyone got any ideas on this? Seems to be stumping the internet

 

[RoryA]

Do you mean PowerPivot tables, or PowerPivot Pivot Tables?