locked
Power pivot Tables Auto Refresh? RRS feed

  • Question

  • Is there a way to have your tables refresh at opening of the file? I have created a report and have data sources that I refresh manually right now but I would like to have a setting where the newest data would be available once the report is opened.

    Thursday, April 25, 2013 5:58 PM

Answers

All replies

  • It is possible using VBA.

    If you are using 2010 it's far from straightforward but can be done. Here are the details of the required technique devised by Tom Gleeson.

    If you are using 2013 it is far simpler as the data model is formally exposed to VBA. Details here.

    The idea is to put the VBA in the workbook module and use the 'Open Event'. I don't know if you have any VBA experience but this technique is outlined here.

    Jacob

    • Marked as answer by Elvis Long Thursday, May 2, 2013 5:51 AM
    Thursday, April 25, 2013 9:37 PM
  • Hi ,

        you can set the refresh option for the datamodel.

    Tuesday, May 7, 2013 7:40 AM