Correct. They are doing updates but none that need to be saved. Using the data wizard I connected workbook A to workbook B already and it works but i can only open workbooks A in read only unless Workbook B is closed and vice versa.

My team will be making their own edits to the workbook throughout the day but if this works would press a refresh button to receive the new data from workbook A.


Can I import workbook A into access and link it to another local table that could be imported into workbook B? I am new to access and don't know databases very well.

Thank you again for your input.