View Single Post
  #1  
Old March 29th, 2010, 07:48 PM posted to microsoft.public.excel.links
neilw2194
external usenet poster
 
Posts: 1
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?




--
neilw2194
Ads