View Single Post
  #1   Report Post  
Old March 29th 10, 07:48 PM
neilw2194 neilw2194 is offline
Junior Member
 
First recorded activity by ExcelBanter: Mar 2010
Posts: 2
Default 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:
..\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?