If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking to Worksheets on Excel -Saved Web Page
I'm working with the Dept. of Homeland Security and need help. I've saved an
Excel 2000 workbook as a web page. It has 9 worksheets, which can be navigated through in the IE browser. However, I cannot link directly to individual worksheets other than the defaultopened when saved. Is there a way to create links from other pages into each of the sheets in the workbook? Also using FrontPage 2002 in Win 2000. |
#2
|
|||
|
|||
I think wha tyou want to do is link to the file then the position the syntax
would look something like this: file.xls#sheet!A1 The ! after the sheet name must be there to denote where in the sheet the link should open. Does this work? John "Lawman" wrote: I'm working with the Dept. of Homeland Security and need help. I've saved an Excel 2000 workbook as a web page. It has 9 worksheets, which can be navigated through in the IE browser. However, I cannot link directly to individual worksheets other than the defaultopened when saved. Is there a way to create links from other pages into each of the sheets in the workbook? Also using FrontPage 2002 in Win 2000. |
#3
|
|||
|
|||
Almost. Such links work when built and accessed within another Excel
document, but when I try to build links on a web page in FrontPage and access them in my browser, they default to the worksheet showing when the file was last saved. FYI: using FP 2002 SP3, using local Intranet, and Excel document is stored to a Xerox Docushare. "John" wrote: I think wha tyou want to do is link to the file then the position the syntax would look something like this: file.xls#sheet!A1 The ! after the sheet name must be there to denote where in the sheet the link should open. Does this work? John "Lawman" wrote: I'm working with the Dept. of Homeland Security and need help. I've saved an Excel 2000 workbook as a web page. It has 9 worksheets, which can be navigated through in the IE browser. However, I cannot link directly to individual worksheets other than the defaultopened when saved. Is there a way to create links from other pages into each of the sheets in the workbook? Also using FrontPage 2002 in Win 2000. |
#4
|
|||
|
|||
Same exact question. The "#" solution (file.xls#book1) works within Excel
but doesn't seem to do the trick when saved as Internet page. For example, in an Excel Web file, you've got a "main.html" file. Then you have a "main_webfiles" folder which might have "sheet001", "sheet002", and "sheet003" in it. Any hyperlink attempt to get to the underlying sheets in main.html just goes to the default, first sheet. Please help. "Lawman" wrote: Almost. Such links work when built and accessed within another Excel document, but when I try to build links on a web page in FrontPage and access them in my browser, they default to the worksheet showing when the file was last saved. FYI: using FP 2002 SP3, using local Intranet, and Excel document is stored to a Xerox Docushare. "John" wrote: I think wha tyou want to do is link to the file then the position the syntax would look something like this: file.xls#sheet!A1 The ! after the sheet name must be there to denote where in the sheet the link should open. Does this work? John "Lawman" wrote: I'm working with the Dept. of Homeland Security and need help. I've saved an Excel 2000 workbook as a web page. It has 9 worksheets, which can be navigated through in the IE browser. However, I cannot link directly to individual worksheets other than the defaultopened when saved. Is there a way to create links from other pages into each of the sheets in the workbook? Also using FrontPage 2002 in Win 2000. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FIrst page footers | Noel S Pamfree | General Discussion | 7 | December 6th, 2004 08:49 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000 | L Mehl | General Discussion | 2 | July 27th, 2004 07:20 PM |
Linking worksheets in Excel | Frank Kabel | General Discussion | 0 | July 20th, 2004 12:54 AM |
Omit Page # on first page | JethroUK© | New Users | 16 | June 17th, 2004 09:20 PM |