Webpage link to specific Excel worksheet

[Guest]

Hello, have scanned the boards but haven't seen this particular question yet.

I'm trying to develop a link that will open a specific Excel worksheet.
I've seen many suggestions regarding designating a named range in the
worksheet and including that in the link, however, the Excel file is
read-only -- I can not make any changes in the worksheets -- and I don't want
to have to pull each worksheet out as its own file, as the original may be
updated a few times a week, and I'd have to keep updating as well. So, I
want a link that will simply open up the worksheet I want without having to
have named ranges. Is this possible?

 

[Anne Troy]

This worked for me as a hyperlink, even after Book1 was saved with Sheet1 as
the active sheet:
C:\Documents and Settings\Administrator\Desktop\Book1.xls - Sheet3!A1
Though I did get the "hyperlinks may be harmful..." notification.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************