Hi,
I've got a Excel sheet that contains UNC hyperlinks to a large number of PDF's. The file lives along with the PDF's on a folder on the server.
Every now and then however and I can't see a pattern to this, Excel decides to change all the hyperlinks to local ones instead, even though a copy of the file doesn't exist there (C:\Docs and Settings\%username%\application data\microsoft\excel\filename.pdf).
I then need to go and restore from the most recent backup which is really beginning to get on my nerves. Any ideas why it might be doing this? Had a Google, and some of the suggestions won't work, i.e adding the path to the "Open when Excel Starts" option, as they're not all Excel files of course.
I've got a Excel sheet that contains UNC hyperlinks to a large number of PDF's. The file lives along with the PDF's on a folder on the server.
Every now and then however and I can't see a pattern to this, Excel decides to change all the hyperlinks to local ones instead, even though a copy of the file doesn't exist there (C:\Docs and Settings\%username%\application data\microsoft\excel\filename.pdf).
I then need to go and restore from the most recent backup which is really beginning to get on my nerves. Any ideas why it might be doing this? Had a Google, and some of the suggestions won't work, i.e adding the path to the "Open when Excel Starts" option, as they're not all Excel files of course.
Comment