excel 2010 hyperlinks breaking when moving file
Posted on 2013-01-24
I am having all kinds of trouble with keeping hyperlinks working. Problem first noticed when I moved the file from one network directory to another. Then, I was updating all the hyperlinks one by one to fix. I got about halfway through, and now some work and some don't. I have also messed around some with setting the File/Properties/hyperlink base setting.
I have also tried setting the hyperlink by navigating to the mapped network drive and also by setting using the longer full UNC path.
I just want to know - what is the secret to setting a hyperlink and making it continue to work - even if I move the file. And, what path should I have in the File/Properties/hyperlink base setting?