1 file multiple worksheets

[dismas]

I have a workbook with 30 worksheets in it.
I need to be able to open it from a web link using the same file, bu
each link able to open to a specific worksheet.

Is there a way to open a saved workbook by adding a suffix to th
specific worksheet.

I have tried several things but none work. Here are some examples tha
may clarify what I am asking.

The saved file is workbook.xls

workbook.xls#sheet4
workbook.xls!sheet 6


Thanks,
Disma

 

[Dave Peterson]

I don't speak HTML, but in MSWord, I can put a hyperlink that looks like this:

C:\My Documents\excel\book1.xls#sheet1!c9

Maybe you can have 30 different links--each slightly different.

 

[dismas]

Bravo Dave! Thanks for your help.
This works for me.

Here is an additional problem that I have encountered.

If the file is left in cache, IE wont load the next tab selection tha
may be contained in another an additional url.

To access the same workbook successively, hitting different workshee
tabs...I have to keep the workbook from staying in cache memory:

I have turned off history in IE and set IE to empty the temp file whe
the browzer is closed.

This works but I am wondering if anyone knows of a more robust way o
handling this problem.



Thanks,
Disma

 

[Dave Peterson]

If you don't get an answer from this post, you may want to post in one of the
internet explorer newsgroups.

 

[Lady Layla]

Unfortunatley Dismas, the set IE to empty temp file when closed does nothing.

: Bravo Dave! Thanks for your help.
: This works for me.
:
: Here is an additional problem that I have encountered.
:
: If the file is left in cache, IE wont load the next tab selection that
: may be contained in another an additional url.
:
: To access the same workbook successively, hitting different worksheet
: tabs...I have to keep the workbook from staying in cache memory:
:
: I have turned off history in IE and set IE to empty the temp file when
: the browzer is closed.
:
: This works but I am wondering if anyone knows of a more robust way of
: handling this problem.
:
:
:
: Thanks,
: Dismas
:
:
: ---
: Message posted
: