Hyperlink To A Specific Worksheet in Excel 2007
I am trying to create a hyperlink in a webpage (using Frontpage 2003) to a specific worksheet in an excel 2007 file. I have tried:
in the last example, I defined a name for a cell within the target worksheet.
All of the above result in the Excel file opening on the worksheet that was displayed when the file was last saved.
I have a suspicion that this functionality worked in older versions of Excel.