Forum Discussion

rwmhr's avatar
rwmhr
Copper Contributor
Aug 07, 2020
Solved

Excel Query Does not Refresh when File Closed

Hello, The Excel (Excel 2016) query automatic refresh does not refresh when the workbook is closed.  It does when it is open.  The Refresh Control under the connection Properties is set to Refresh e...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 07, 2020

    rwmhr 

    Nothing happens within workbook till it is closed. You may use PowerShell or third-party utility which will be scheduled through tasks, when work it opens workbook, refresh it and close after that.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 07, 2020

rwmhr 

Nothing happens within workbook till it is closed. You may use PowerShell or third-party utility which will be scheduled through tasks, when work it opens workbook, refresh it and close after that.

  • rwmhr's avatar
    rwmhr
    Copper Contributor
    Aug 07, 2020

    Thank you Sergei.

    I think I will just have to set it up to refresh when the user opens it.

    Thanks.  Have a great weekend.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 07, 2020

      rwmhr 

      have a nice weekend too

Resources