Aug 07 2020 08:33 AM
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 every 2 minutes. The worksheet is drawing data from another workbook, both in the network drive. Am I missing a setting? I even tried using VBA code but not good either. I would appreciate any help or suggestions.
Thank you in advance.
Aug 07 2020 09:53 AM
SolutionNothing 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.
Aug 07 2020 11:24 AM
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.
Aug 07 2020 12:11 PM
have a nice weekend too
Aug 07 2020 09:53 AM
SolutionNothing 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.