The other day I wanted to insert a hyperlink to another spreadsheet.
I hardly ever put Hyperlinks into Spreadsheets – I almost always link to a web page. This time, however, I wanted to link to a document on the file server.
Insert – Hyperlink – Double click the file – done! “Wow! that was easy” I thought, then promptly attached and e-mailed the spreadsheet to the customer.
“Great spreadsheet” was the feedback, “but the hyperlink is broken – it’s pointing to my C: drive!”
It appears as though hyperlinks are stored by relative path (rather than absolute path) when the linked document is on the same Network Share. His e-mail program had saved the attached spreadsheet to C:\Temp before opening it, so the hyperlink also looked to the C: drive.
When I hover my mouse pointer over a hyperlink, the tool tip reveals the true path.
Here is me hovering over the hyperlink from my computer:
Here is my customer hovering over the hyperlink from their computer:
Fixed it – Here is my customer hovering over the fixed hyperlink from their computer:
What’s the difference between the first and last hyperlink?
The last hyperlink is actually a formula which forces an absolute path: