Search code examples
excelpivotpowerpivotvba

Refresh Power Pivot Window

How to automatically Refresh Power Pivot Window when i open excel file , without going the Power Pivot Window option in power pivot tab?

Solution

  • Vinoth,

    It is possible to write VBA that triggers a 'refresh all' by placing the code in the Workbook module and using the Open_Event to trigger it as the workbook is opened.

    If you are using 2010 then you will need to use this highly innovative technique developed by a guy called Tom Gleeson.

    If you are using 2013 then things become more straightforward as the data model is formally exposed to VBA. There are several resources out there including this.

    HTH Jacob