Hi
Situation; taken a copy of a sub directory containing 4 excel files which are linked to each other. Using the copied versions of the file I've renamed the modified the file names through Windows Explorer. For example 'File 1 140513' to 'File 1 310513') - essentially the copied files are ensuring you have version control. Then on opening all the files through excel I go to change the links in order to remap to the new files. On changing the links to one of the file's it needs updating for each cell reference link rather than changing the link to all cells on mass. Any ideas? One supporting issue could be the use of long formula which contains reference to this file.
Any ideas / solutions, much appreciated?
Thanks
Mizogy
Situation; taken a copy of a sub directory containing 4 excel files which are linked to each other. Using the copied versions of the file I've renamed the modified the file names through Windows Explorer. For example 'File 1 140513' to 'File 1 310513') - essentially the copied files are ensuring you have version control. Then on opening all the files through excel I go to change the links in order to remap to the new files. On changing the links to one of the file's it needs updating for each cell reference link rather than changing the link to all cells on mass. Any ideas? One supporting issue could be the use of long formula which contains reference to this file.
Any ideas / solutions, much appreciated?
Thanks
Mizogy
