I have an excel workbook that has three tables linked via SQL Server. Right now, the data is refreshed when the user opens the file. Due to the large tables, it can take a minute or two before the refresh in done. Is there VBA code that I can use to refresh all my tables at a specific time (6:30 am) of the day without the user actually opening the file?
Thank You!