Hello,
I've seen similar issues to this one, but haven't come across an exact answer yet. I have a workbook on a share. Let's say it's called \\myshare\myfolder. In many formulas, there are links to a couple of other files, \\myshare\anotherfolder\anotherfile, for example.
If I use Explorer to copy the Excel file from the share and place on my desktop, and then open the file, all the formulas change from \\myshare\anotherfolder\another file to c:\anotherfolder\anotherfile.
The issue is that I would like to preserve the links to the fileshare even though I am copying the primary file to my desktop.
I've searched the forums and others have said that Microsoft keeps relative references, by design, to other files.
So, my question is: is there a way to override this? There are only several external files that my main file is linked to, but these links are in many cells. I have tried to use the Edit Links dialogue box to change the source file from "the bad one" on my desktop to the one on the server. But, since there are many links, Excel hangs, for all practical purposes.
My ideal solution would be to avoid having the links updated in the first place. I figured that if this was successfully solved, it wold be in this forum.
Thanks,
Scotty81
I've seen similar issues to this one, but haven't come across an exact answer yet. I have a workbook on a share. Let's say it's called \\myshare\myfolder. In many formulas, there are links to a couple of other files, \\myshare\anotherfolder\anotherfile, for example.
If I use Explorer to copy the Excel file from the share and place on my desktop, and then open the file, all the formulas change from \\myshare\anotherfolder\another file to c:\anotherfolder\anotherfile.
The issue is that I would like to preserve the links to the fileshare even though I am copying the primary file to my desktop.
I've searched the forums and others have said that Microsoft keeps relative references, by design, to other files.
So, my question is: is there a way to override this? There are only several external files that my main file is linked to, but these links are in many cells. I have tried to use the Edit Links dialogue box to change the source file from "the bad one" on my desktop to the one on the server. But, since there are many links, Excel hangs, for all practical purposes.
My ideal solution would be to avoid having the links updated in the first place. I figured that if this was successfully solved, it wold be in this forum.
Thanks,
Scotty81