Power Pivot Linked Tables Refresh

Hi there,

I'm hoping I can leverage the collective.

Issue:

I am using power pivot to join tables that I need to make the pivots work properly. I've set the pivots to update on entry and that didn't work.

I had to manually go to power pivot and refresh all the linked tables then run a refresh.

Dim xWs As Worksheet
Dim xTable As PivotTable
For Each xWs In Application.ActiveWorkbook.Worksheets
For Each xTable In xWs.PivotTables
xTable.RefreshTable
Next
Next

I tried to cheat and record a macro of me doing the linked table refresh but it didn't record.

Do you know of a way to update the linked table via VBA?

If so, please let me know.

Thank you in advance.

2010, yup.
Oh my. That is dirty huh.