Links between Multiple Spreadsheets

[Amy Beryl]

Hi All -

Here's the issue: we have 5 large spreadsheets that link to one master spreadsheets also large. All 6 sheets and the folder they reside in are named with the 2 digit year. We prepare the set of 6 sheets each year with what seems to be a zillion links each pointing to a file that has that 2 digit year. Ok, next year rolls around we make a new folder with the new 2 digit year and we want to copy over the 6 files and give all of them the same names by with the new 2 digit year. What is the least painful way to update the links to use the new folder and the newly changed file names in the link formulas?

Thanks!

Amy

 

[Logit]

.
One method would be to place the YEAR as the first part of the file name instead of the last part. Always name the files the same as the previous year
except for the year number which is located at the front of the file name.

18-ThisIsMyFileName-A.xlsm

18-ThisIsAnotherFileName-B.xlsm

18-AndHereIsAnotherFileName-C.xlsm

Now your links can refer to the last part of each file name ... A ... B ... C ... etc.

If 26 different files are not enough, use numbers instead of letters. That will give you an unlimited number of file names.