locked
MS Excel Power Query not refresh if file is not open when choosing Refresh every x minutes RRS feed

  • General discussion

  • I'm using MS Excel 2013 with Power Query add-in.

    I have a table with data source from Oracle. Everything is ok - I can manually refresh the data, etc.

    Then I want to setup auto refresh by the following:

    in the "Connection Properties", in Usage tab, under Refresh control, I choose "Refresh every 5 minutes".

    I saved the file and close the excel file.

    After 5 minutes, I opened the file and found the data was NOT refreshed.

    However, if I open the file and keep it open for 5 minutes, I can see the data is automatically refreshed.

    Anyone knows why the closed file cannot get refreshed as configured or this is the requirement by MS Excel to keep the file open for refreshing data in regular basis (every x minutes)?

    Any suggestion? What I want is to avoid human intervention and have file refreshed when it is closed (I know there is an option to refresh data when opening the file).

    

    Wednesday, June 21, 2017 8:13 PM