sth about hyperlink

  • Thread starter Thread starter =?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=
  • Start date Start date
?

=?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=

hi,
i add a hyperlink to a cell to link another cell in the same sheet.

then i save the sheet as a webpage.

to my disappointment , the link failed when i tried in the webpage.

why.

thank you
 
If your publishing the page to a website you'd have to also place th
excel docs to the site as well.

Also, if you publish your page to a website you hyperlink will b
pointing to your harddrive drive structure, which is not accessable vi
the web. You link could look like (c:/my documents/file.html) i
should be something like (/files/)

hope that help
 
What are you using for a hyperlink to link on the same page.
http://www.mvps.org/dmcritchie/excel/sheets.htm

The following might work for you. Reply if it works or not.
to link to cell D27 in your hyperlink use #D27
for worksheet formula use: =HYPERLINK("#D27",D27)
or better because it will adjust for inserted/deleted rows|columns|cells
=HYPERLINK("#"&CELL("address",C5),C5)

I don't use the builtin HTML conversions (Save As: HTML)
 
thank you for your advice.
i wonder what is the difference between using a hyperlink function and using
the right button menu of hyperlink.
as a matter of fact neither will be ok when as a webpage.
 
The HYPERLINK Worksheet Formula generally has the
address withing quotes so does not adjust when you insert
rows or delete rows. It is calculated where to go when you
take the link.
=HYPRLINK("http://www.ibm.com","IBM")
By using "#" within the link you can specify
a link within the same sheet in Excel 97 and up (I have Excel 2000),
to reference a cell on the same sheet without having to specify
the workbookname. Excel 2002 made this better so you did not need
to speficity the workbookname.
=HYPERLINK("[vlookuptest.xls]'sheet1'!B2","back to B2")
=HYPERLINK("#"&CELL("address",C158),"down to C158")
But the HYPERLINK formulas do not work for me when converted to
HTML. Shows up as an empty page but the Back butt (A+LtArrow)
works fine.

Entry of Right-Click Hyperlinks (object hyperlinks) do work to
refer to cells anywhere in the HTML converted as entire workbook
non-interactive file -- did not test on the web. I have Excel 2000
and chose same workbook sheet1 and the cell name to link to.
This form of hyperlink will adjust properly when you insert/delete
rows/columns and certainlhy works fine withing Excel, and it worked
for me on the file converted to HTML but only tested on my harddrive.

Round Tripping is where you start in one Office application and
convert to another application (or HTML), posibly converting that
another Office application (or HTML), repleat same stuff, and
finally back to the original (hence round trip) where you are supposed
to have a useable file with no features lost. In reality this is very
expensive. The generated code is about 4 times larger than if you
coded manually. Much worse if you go from Excel to Front Pagea
and then to HTML by pasting from Excel into F.P. and then creating
the HTML it is 14 times larger than coded manually. A very high price
for dial-up access and for disk storage.

With all the effort on round tripping, I am surprised that you
indicate that the links don't work on the web site.

As I indicated earlier in thread I don't use the Save As facilities
in Excel, I generate my own HTML with a macro, and the sole
purpose is to create a table to copy the table source to an HTML
file I manually create and update. So it's not really designed to
create a web page. Because it is stupid and doesn't know about
HTML, I can simply code <a href="http://www.ibm.com">IBM</a>
and that cell in the HTML table will have a link once within HTML.
http://www.mvps.org/dmcritchie/excel/xl2html.htm


Please read my page concerning hyperlinks with
worksheet formulas though it won't help with web
stuff. http://www.mvps.org/dmcritchie/excel/sheets.htm


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: =HYPERLINK("[vlookuptest.xls]'sheet1'!B2","back to B2")
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top