I have a master file with 20 tabs that is linked to 20 seperate files. All of those 20 files have the same formulas just with different file names. I need to create another file in the master and link that to another seperate (new) file.
Is there a way to mass update the linking of the new file name in the master file? I would hate to have to re-define each cell.