How can I create a HTML link that automatically opens an existing xls file to a particular worksheet?

So far google has yielded:

a href="filename.xls#worksheetname"

but that doesn't work. When you click on that link it immediatley goes to the open/save dialog and only opens the file when you click on open. It does not automatically change to the worksheet indicated in the link.

2/6/2006 11:02:02 AM

so you have a normal XLS file that you put online and have a link to it?

Normally, when you save an Excel workbook, the next time you open it, it automatically goes to the worksheet that was opened when it was saved. Does this not work for a linked workbook? What about saving the worksheet as HTML - do you want to just present data, or do you want them to actually download the XLS file?

2/6/2006 11:15:00 AM

there is also a way to export the spreadsheet as an active web page.

Instead of just reformatting it into plain text for display only, it embeds the XLS into the HTML file as active content.

When viewed in a browser you see an applet that contains basic excell functionality.

This requries that the office web components be installed on the viewing machine.



file -> save as

set type to html

click publish

Check "Allow interactivity with" -> spreadsheet functionality

pick a title and file name

publish

[Edited on February 6, 2006 at 11:22 AM. Reason : directions.]

2/6/2006 11:19:53 AM

Thanks for all your input. What I wanted to do was create page (offline) that had a separate link into each page in a workbook. I would have liked to have done it on an html page but in this case I'll settle for making an xls indexing file that does the same thing.

In excel it is done with

=hyperlink("[filename]worksheetname!cellrange", "link name")

so I shouldn't need help with that.

[Edited on February 6, 2006 at 11:48 AM. Reason : t]

2/6/2006 11:47:50 AM