refresh excel data without opening file?

Updat data in closed Excel file without opening it

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.

Run Macro Automatically without Opening Excel File

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.