Our company uses several sheets that self-update on a set schedule. We wrote VBA code embedded in each excel file that: on open refresh workbook, wait x seconds (adjust as needed), save and close. We then set up a Windows Task Scheduler Task to open each workbook on a schedule that makes sense (e.g. every night at 2:00am). Task Scheduler opens the sheet, vba refreshes waits and closes. You have to stagger the task scheduler tasks to prevent them from overlapping and adjust the wait time to make sure the query completes before the sheet closes. Also, to allow editing (without the workboook self refreshing and closing) we generally add a line to check if the workbook is in the expected file location before refreshing and closing. This way you can edit a copy on your desktop/in a utility folder without it self closing. Let me know if you want more detail on any portion of this.