Excel 2013
2 Excel files. A. master source file containing Job numbers. B. Employee timesheet files that refreshes the Job numbers data from master sources file when opening the file
The data refresh correctly when I manually click on Refresh All, or use "ActiveWorkbook.RefreshAll" in Workbook_Open. However, this locks up the Master source file until I close out of the timesheet. This solution is not going to work since it only allows one employee to update timesheet at a time.
Also tried the following code to refresh data, which works for other data connections already in the timesheet file (setup by predecessor), but for whatever reason, it doesn't work for the new job number connection.
Please advise if there is a way to end the connection after the data is refreshed so the source file is not locked. Or, what do I need to change on the data connection to enable the Sheet1.querytables to work.
Please help. Thanks in advance.
Bookmarks