I have a set of separate workbooks that all live in the same folder and reference data within each other. Basically they are a header table and then several detail tables and are used to record inspection data at each of the machining operations in our machine shop.
When we machine a new batch, I want to create a folder for that job and copy a master set of the workbooks into the new folder.
The problem I am having is that the data references are looking back to the original location. I can edit the connections, but that is time consuming.
I have set up the ranges in the various workbooks as names if that makes any difference.
Any suggestions?
When we machine a new batch, I want to create a folder for that job and copy a master set of the workbooks into the new folder.
The problem I am having is that the data references are looking back to the original location. I can edit the connections, but that is time consuming.
I have set up the ranges in the various workbooks as names if that makes any difference.
Any suggestions?
