View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Stabosz Michael Stabosz is offline
external usenet poster
 
Posts: 1
Default Edited links keep reverting when we save a shared network file.

Addendum: Okay, so Excel seems to, no matter what I do, save links to files
in other directories as paths relative to where the spreadsheet currently is.
So for example, one link points to "../../../PUBLIC/Quotes/NJ" Reading that
normally, you know it's telling the computer to back up three directories in
the directory structure then down into the PUBLIC folder, then Quotes, then
NJ. Yeah fine. Those directories exist but Excel won't go to them. Could
be a network problem on our end, but... well it's actually pretty irrelevant.
I want to give them absolute path names, none of this "back up three
directories then follow these subdirectories" nonsense. And I want these
changes to STAY instead of reverting to the relative pathnames. I'm getting
frustrated .<