I've been using Excel heavily for over a decade, but this problem's got me totally and utterly stumped. I've got a worksheet which is a list of documents. In a series of columns I've got metadata about those documents (date, author etc). One of the fields is a hyperlink to the doc itself, constructed like this:
=HYPERLINK($B$1&"path","display name")
Cell B1 is the first part of the filepath, so this makes it easy to move the spreadsheet and the docs to a different file area (e.g. a CD) with only one cell to change (almost like a relative file path, such as you would use in html).
The spreadsheet has been working just fine for about two months, and I've been populating the spreadsheet with great success. However, yesterday I went to edit one of the Hyperlink formulae and when I pressed return it just showed the formula, not the hyperlink. If I copy another working hyperlink formula in from another cell, it works, but if I click to edit the formula and then press return (even without making a change), it just shows the formula again, not the hyperlink. All of my hyperlinks are now doing this, in every cell.
Things I've checked:
Format of the cells - I've tried various formatting options and nothing works.
Auto-Calculate - I've tried this on and off, plus F9 and shift-F9
Conditional Formatting - none applied, and I've tried clearing all.
Any ideas would be greatly appreciated.
thanks for reading.
PS - this may be a keyboard shortcut; I have two cats that often walk around on the keyboard and they have a habit of finding the most obscure keyboard shortcuts imaginable!
Bookmarks