Linking to Excel Spreadsheets

[dollarbill13]

I have an excel workbook with 12 sheets that I have saved as a web page. What I would like to do is have 12 links in a top frame that would open the spreadsheet with a different sheet selected. So basically if someone clicks "Link 1", the link opens the spreadsheet with page 1 selected... Link 2 would open the spreadsheet with page 2 selected. Is this possible?

 

[Anne Troy]

Insert named ranges, such as "Sheet6" for sheet 6, cell A1.

Then use the link:

....filename.xls#Sheet6

 

[dollarbill13]

Seeing as it is saved as a web page, can I use the link:

... filename.htm#Sheet6

?

 

[Anne Troy]

Probably not. Then you must insert a bookmark using HTML, I suspect.