Excel updated links automatically - help
Posted on 2011-09-19
We have a rather complex system that has been created using excel and uses links to other files spread in several directories.
Today we have noticed that all the file locations have been updated meaning the calculation sheets can not be updated. All the links have been updated in the same way, for example the link should read:
however it now reads:
The share name seems to have been duplicated. However this has not happened to excel documents that reference an excel document in the same folder.
What I need to understand is why this has happened and any possible resolutions.
Many thanks for taking time to read this.