Skip to content

Excel PowerPivot

Refresh Data Model/PowerPivot Table Through VBA

ActiveWorkbook.Model.Refresh

SOURCE: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/561c7709-ba35-4bd3-afa5-726d1f2727e7/autorefresh-powerpivot-table-in-excel?forum=sqlkjpowerpivotforexcel