PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Word > Microsoft Frontpage > Can I link to a Sheet Tab in an Excel Spreadsheet?

Reply
Page 1 of 2 1 2
Thread Tools Rate Thread

Can I link to a Sheet Tab in an Excel Spreadsheet?

 
 
Dave
Guest
Posts: n/a
 
      3rd Jun 2004
I have a 3 page spreadsheet that has been saved as an HTM document and
posted on a site. Everything works fine.

However it would be even more user friendly if I could link directly to a
particular sheet in the spreadsheet. I am using Excel 2000 and FP 2003.

Thanks

Dave K
 
Reply With Quote
 
 
 
 
Stefan B Rusynko
Guest
Posts: n/a
 
      3rd Jun 2004
Try using the sheet name as a bookmark
<a href="workbookname.htm#worksheetname">the sheet</a>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| I have a 3 page spreadsheet that has been saved as an HTM document and
| posted on a site. Everything works fine.
|
| However it would be even more user friendly if I could link directly to a
| particular sheet in the spreadsheet. I am using Excel 2000 and FP 2003.
|
| Thanks
|
| Dave K
|
|
 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      3rd Jun 2004
Thanks for the quick response.

How do you bookmark a sheet in Excel? I did a quick search and did not get
a bookmark return.

I think that this IS the solution - thanks.

I know that I can bookmark the HTM version, but I would like to bookmark the
original Excel sheet.

Dave

"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try using the sheet name as a bookmark
> <a href="workbookname.htm#worksheetname">the sheet</a>
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> | I have a 3 page spreadsheet that has been saved as an HTM document and
> | posted on a site. Everything works fine.
> |
> | However it would be even more user friendly if I could link directly to
a
> | particular sheet in the spreadsheet. I am using Excel 2000 and FP 2003.
> |
> | Thanks
> |
> | Dave K
> |
> |
>
>
 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      3rd Jun 2004
I tried using the sheet name and no luck, but I think this will work if I
can figure out how.

Dave

"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try using the sheet name as a bookmark
> <a href="workbookname.htm#worksheetname">the sheet</a>
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> | I have a 3 page spreadsheet that has been saved as an HTM document and
> | posted on a site. Everything works fine.
> |
> | However it would be even more user friendly if I could link directly to
a
> | particular sheet in the spreadsheet. I am using Excel 2000 and FP 2003.
> |
> | Thanks
> |
> | Dave K
> |
> |
>
>
 
Reply With Quote
 
Bill Schroyer
Guest
Posts: n/a
 
      3rd Jun 2004
Open the target page in FrontPage and click > Insert
Bookmark. Then go the page with the link, on the right
choose bookmark.

Bill Schroyer
(E-Mail Removed)
http://www.frontpagewiz.com
>-----Original Message-----
>Thanks for the quick response.
>
>How do you bookmark a sheet in Excel? I did a quick
search and did not get
>a bookmark return.
>
>I think that this IS the solution - thanks.
>
>I know that I can bookmark the HTM version, but I would
like to bookmark the
>original Excel sheet.
>
>Dave
>
>"Stefan B Rusynko" <(E-Mail Removed)> wrote in
message
>news:(E-Mail Removed)...
>> Try using the sheet name as a bookmark
>> <a href="workbookname.htm#worksheetname">the sheet</a>
>>
>> --
>>
>> _____________________________________________
>> SBR @ ENJOY (-: [ Microsoft MVP -
FrontPage ]
>> "Warning - Using the F1 Key will not break anything!"
(-;
>> To find the best Newsgroup for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> _____________________________________________
>>
>>
>> "Dave" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> | I have a 3 page spreadsheet that has been saved as an
HTM document and
>> | posted on a site. Everything works fine.
>> |
>> | However it would be even more user friendly if I
could link directly to
>a
>> | particular sheet in the spreadsheet. I am using
Excel 2000 and FP 2003.
>> |
>> | Thanks
>> |
>> | Dave K
>> |
>> |
>>
>>
>
>
>.
>
 
Reply With Quote
 
Bill Schroyer
Guest
Posts: n/a
 
      3rd Jun 2004
Save each sheet as a seperate workbook.

Bill
>-----Original Message-----
>I tried using the sheet name and no luck, but I think
this will work if I
>can figure out how.
>
>Dave
>
>"Stefan B Rusynko" <(E-Mail Removed)> wrote in
message
>news:(E-Mail Removed)...
>> Try using the sheet name as a bookmark
>> <a href="workbookname.htm#worksheetname">the sheet</a>
>>
>> --
>>
>> _____________________________________________
>> SBR @ ENJOY (-: [ Microsoft MVP -
FrontPage ]
>> "Warning - Using the F1 Key will not break anything!"
(-;
>> To find the best Newsgroup for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> _____________________________________________
>>
>>
>> "Dave" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> | I have a 3 page spreadsheet that has been saved as an
HTM document and
>> | posted on a site. Everything works fine.
>> |
>> | However it would be even more user friendly if I
could link directly to
>a
>> | particular sheet in the spreadsheet. I am using
Excel 2000 and FP 2003.
>> |
>> | Thanks
>> |
>> | Dave K
>> |
>> |
>>
>>
>
>
>.
>
 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      3rd Jun 2004
It only works (using the sheet name) if you are linking to a .xls file
If you have a workbook w/ worksheets saved as .htm then the sheets are hidden windows thicket files
When you file Preview in Browser you can see the links by mousing over the sheet tabs

Each work sheet is in a hidden thicket folder named Workbook_files
(where "Workbook" is your file excel.htm filename w/o the extension)
And the sheet htm pages are numbered from 001 to 00X, as sheet001.htm thru sheet00X.htm
So a hyperlink to sheet 3 of the workbook myspreadsheet.htm would be entered as
myspreadsheet_files/sheet003.htm

Create a hyperlink to the work book
Then edit the hyperlink to add the sheet part
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| I tried using the sheet name and no luck, but I think this will work if I
| can figure out how.
|
| Dave
|
| "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
| news:(E-Mail Removed)...
| > Try using the sheet name as a bookmark
| > <a href="workbookname.htm#worksheetname">the sheet</a>
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > "Dave" <(E-Mail Removed)> wrote in message
| news:(E-Mail Removed)...
| > | I have a 3 page spreadsheet that has been saved as an HTM document and
| > | posted on a site. Everything works fine.
| > |
| > | However it would be even more user friendly if I could link directly to
| a
| > | particular sheet in the spreadsheet. I am using Excel 2000 and FP 2003.
| > |
| > | Thanks
| > |
| > | Dave K
| > |
| > |
| >
| >
|
|
 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      3rd Jun 2004

"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> It only works (using the sheet name) if you are linking to a .xls file
> If you have a workbook w/ worksheets saved as .htm then the sheets are
hidden windows thicket files
> When you file Preview in Browser you can see the links by mousing over the
sheet tabs
>
> Each work sheet is in a hidden thicket folder named Workbook_files
> (where "Workbook" is your file excel.htm filename w/o the extension)
> And the sheet htm pages are numbered from 001 to 00X, as sheet001.htm thru
sheet00X.htm
> So a hyperlink to sheet 3 of the workbook myspreadsheet.htm would be
entered as
> myspreadsheet_files/sheet003.htm
>
> Create a hyperlink to the work book
> Then edit the hyperlink to add the sheet part
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> | I tried using the sheet name and no luck, but I think this will work if
I
> | can figure out how.
> |
> | Dave
> |
> | "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> | news:(E-Mail Removed)...
> | > Try using the sheet name as a bookmark
> | > <a href="workbookname.htm#worksheetname">the sheet</a>
> | >
> | > --
> | >
> | > _____________________________________________
> | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > "Warning - Using the F1 Key will not break anything!" (-;
> | > To find the best Newsgroup for FrontPage support see:
> | > http://www.net-sites.com/sitebuilder/newsgroups.asp
> | > _____________________________________________
> | >
> | >
> | > "Dave" <(E-Mail Removed)> wrote in message
> | news:(E-Mail Removed)...
> | > | I have a 3 page spreadsheet that has been saved as an HTM document
and
> | > | posted on a site. Everything works fine.
> | > |
> | > | However it would be even more user friendly if I could link directly
to
> | a
> | > | particular sheet in the spreadsheet. I am using Excel 2000 and FP
2003.
> | > |
> | > | Thanks
> | > |
> | > | Dave K
> | > |
> | > |
> | >
> | >
> |
> |
>
>
 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      3rd Jun 2004
I appreciate your help.

I am using frames and FP2003, I don't know if this is the issue.

I set the link in the upper frame. When I mouse over the link, I get the
address of sheet002.htm. When I mouse over corresponding sheet tab, I get
the exact same link.

If I click the Second Sheet Tab all is well. If I click the link I created,
is launches the spreadsheet htm page, not the correct sheet of that
spreadsheet.

I know that I am missing something.

Thanks again

Dave

"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> It only works (using the sheet name) if you are linking to a .xls file
> If you have a workbook w/ worksheets saved as .htm then the sheets are
hidden windows thicket files
> When you file Preview in Browser you can see the links by mousing over the
sheet tabs
>
> Each work sheet is in a hidden thicket folder named Workbook_files
> (where "Workbook" is your file excel.htm filename w/o the extension)
> And the sheet htm pages are numbered from 001 to 00X, as sheet001.htm thru
sheet00X.htm
> So a hyperlink to sheet 3 of the workbook myspreadsheet.htm would be
entered as
> myspreadsheet_files/sheet003.htm
>
> Create a hyperlink to the work book
> Then edit the hyperlink to add the sheet part
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> _____________________________________________
>
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> | I tried using the sheet name and no luck, but I think this will work if
I
> | can figure out how.
> |
> | Dave
> |
> | "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
> | news:(E-Mail Removed)...
> | > Try using the sheet name as a bookmark
> | > <a href="workbookname.htm#worksheetname">the sheet</a>
> | >
> | > --
> | >
> | > _____________________________________________
> | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > "Warning - Using the F1 Key will not break anything!" (-;
> | > To find the best Newsgroup for FrontPage support see:
> | > http://www.net-sites.com/sitebuilder/newsgroups.asp
> | > _____________________________________________
> | >
> | >
> | > "Dave" <(E-Mail Removed)> wrote in message
> | news:(E-Mail Removed)...
> | > | I have a 3 page spreadsheet that has been saved as an HTM document
and
> | > | posted on a site. Everything works fine.
> | > |
> | > | However it would be even more user friendly if I could link directly
to
> | a
> | > | particular sheet in the spreadsheet. I am using Excel 2000 and FP
2003.
> | > |
> | > | Thanks
> | > |
> | > | Dave K
> | > |
> | > |
> | >
> | >
> |
> |
>
>
 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      3rd Jun 2004
Post the URL to your page online or a code snippet showing your hyperlink tag

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| I appreciate your help.
|
| I am using frames and FP2003, I don't know if this is the issue.
|
| I set the link in the upper frame. When I mouse over the link, I get the
| address of sheet002.htm. When I mouse over corresponding sheet tab, I get
| the exact same link.
|
| If I click the Second Sheet Tab all is well. If I click the link I created,
| is launches the spreadsheet htm page, not the correct sheet of that
| spreadsheet.
|
| I know that I am missing something.
|
| Thanks again
|
| Dave
|
| "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
| news:(E-Mail Removed)...
| > It only works (using the sheet name) if you are linking to a .xls file
| > If you have a workbook w/ worksheets saved as .htm then the sheets are
| hidden windows thicket files
| > When you file Preview in Browser you can see the links by mousing over the
| sheet tabs
| >
| > Each work sheet is in a hidden thicket folder named Workbook_files
| > (where "Workbook" is your file excel.htm filename w/o the extension)
| > And the sheet htm pages are numbered from 001 to 00X, as sheet001.htm thru
| sheet00X.htm
| > So a hyperlink to sheet 3 of the workbook myspreadsheet.htm would be
| entered as
| > myspreadsheet_files/sheet003.htm
| >
| > Create a hyperlink to the work book
| > Then edit the hyperlink to add the sheet part
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > "Dave" <(E-Mail Removed)> wrote in message
| news:(E-Mail Removed)...
| > | I tried using the sheet name and no luck, but I think this will work if
| I
| > | can figure out how.
| > |
| > | Dave
| > |
| > | "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
| > | news:(E-Mail Removed)...
| > | > Try using the sheet name as a bookmark
| > | > <a href="workbookname.htm#worksheetname">the sheet</a>
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > "Dave" <(E-Mail Removed)> wrote in message
| > | news:(E-Mail Removed)...
| > | > | I have a 3 page spreadsheet that has been saved as an HTM document
| and
| > | > | posted on a site. Everything works fine.
| > | > |
| > | > | However it would be even more user friendly if I could link directly
| to
| > | a
| > | > | particular sheet in the spreadsheet. I am using Excel 2000 and FP
| 2003.
| > | > |
| > | > | Thanks
| > | > |
| > | > | Dave K
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|
 
Reply With Quote
 
 
 
Reply
Page 1 of 2 1 2

« cad file downloads | Can't resize Pop Up window with SPAWN »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make spreadsheet content link to another sheet and have. Hyperlinking Spreadsheets Microsoft Excel Misc 6 29th Aug 2008 03:01 AM
How do I link an excel spreadsheet or spreadsheet like data to a f Stuart Reicher Microsoft Access Forms 7 7th Jan 2008 11:10 PM
Excel how do I link text values in one sheet to another sheet? =?Utf-8?B?Y2hyaXNqdG0=?= Microsoft Excel Misc 3 9th Mar 2006 06:09 AM
Program link to Excel spreadsheet opens Excel but not spreadsheet =?Utf-8?B?Y2I=?= Microsoft Excel Crashes 1 11th Feb 2006 02:55 PM
Excel linking nightmare- horizontal excel spreadsheet link =?Utf-8?B?eW95b3lvb3Jlbw==?= Microsoft Word Document Management 2 24th Sep 2004 11:03 PM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 10:59 PM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top