My hyperlinks are being changed when I hit save in excel. Eg a perfectly good hyperlink, which works well…
\\wwleeds-srv\wwstandards\Technical_Guides\Part_L_information\CIBSE_guide_F_Energy_efficiency_in_buildings.pdf
...changes to an unusable string of nonsense on hitting save:
../../../../../wwstandards/Technical_Guides/Part_L_information/CIBSE_guide_F_Energy_efficiency_in_buildings.pdf
I just don’t know why it changes at all when it saves, it puts all the back slashes to forward slashes, removes the server name and puts in a whole load of forward slashes.
Clicking on the saved hyperlink brings up the error message:
“The address of this site is not valid. Check the address and try again”
I have tried inserting the hyperlink by right clicking on the cell, selecting hyperlink and then browsing to find the file on the server that I’m after, then testing it to see if it works, and it does until I hit save. I then tried fixing it by editing the hyperlink. This also works until I hit save.
Please could you let me know how to solve this problem?
I've checked the microsoft website for help and I think that this is suggesting that I do what I have already done ( http://support.microsoft.com/kb/156893 ), if so it doesn’t work, if not please can you help me with plainer instructions? ( I don't think it works).
Bookmarks