Excel 2007 Hyperlink Limitation13 Jan 2010
For a couple of years now I’ve been pulling IT service desk statistics into a spreadsheet and setting up worksheets to break down and analyse the data in various ways. The number of worksheets has subsequently grown a significant amount and I wanted to create a front worksheet that contained hyperlinks to and brief descriptions for each of the subsequent worksheets.
This is straight forward to do in Excel. Press
CTRL+K to bring up the
hyperlink dialog and select the “Place in this document” set and then
just select the worksheet you want the hyperlink to link to. The issue
I discovered was that this really does only apply to worksheets. I had several
chart sheets inserted into the workbook and these were not being listed
in the hyperlink options.
As a result I’ve copied the charts from each of the chart sheets and pasted them as items on new worksheets. An inelegant solution, but a practical one that doesn’t involve adding a macro to do the job.