I have a series of workbooks that collect weather data each month. One workbook per month.
We have formulas that grab data from earlier workbooks and load into an ongoing table and graph.
Example, February's workbook will grab data from January, etc.
I would like to save these "master" workbooks into several other peoples computers, inside a "master" folder.
My question is, does Excel re-name the formulas so as the saved workbooks are now looking in the proper place for data?
For instance an original formula may read ='C:\Users\Mike\Desktop\Spreadsheets\Master Forms\[Master visit 2 version 022013.xlsm]Field Input'!J4
In the new user's workbook is now save at "Joe" instead of "Mike" will Excel auto-correct that?
I have a number of copies to save with many new users and don't want to load them all and it not work
Thanks!
Bookmarks