We use several spreadsheets that all link to each other, that are in different subfolders on the network share drive.
The path is/should be:
\\server\storage\2015\January
If I modify these spreadsheets from my PC, the links are great... If the others modify them, and save... It changes the path to:
\\server\2015\January
It keeps removing the \storage\ folder from the path... I've verified their shortcuts to this shared drive are correct. We don't use a drive letter for mapping here... There are 1000s of links in some of these workbooks, so I can't go into Edit-->Links--> Change source... without having all the other documents open, because it takes forever to update all the links.
I've been searching for days for solutions, found lots of discussions and people with the issue but not much in terms of help or fixes.
The path is/should be:
\\server\storage\2015\January
If I modify these spreadsheets from my PC, the links are great... If the others modify them, and save... It changes the path to:
\\server\2015\January
It keeps removing the \storage\ folder from the path... I've verified their shortcuts to this shared drive are correct. We don't use a drive letter for mapping here... There are 1000s of links in some of these workbooks, so I can't go into Edit-->Links--> Change source... without having all the other documents open, because it takes forever to update all the links.
I've been searching for days for solutions, found lots of discussions and people with the issue but not much in terms of help or fixes.