I've just spent the best part of a day entering hyperlinks to files in a
shared drive - eg '\\servername\drive\filename.pdf'
After closing the worksheet and opening it up again, I now find that Excel
has amended all the links to '../../drive/filename.pdf' so that when I click
the link it thinks I'm looking for a website and comes up with the error
message - 'The address of the site is not valid. Check the address and try
again.'
I've tried changing one back but the same thing happened as soon as I closed
it and opened it again.
HELP!