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:
..\filename.xlsx\#worksheetname
..\filename.xlsx\#'worksheetname'
..\filename.xlsx\#rangename

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.

Any ideas?