hyperlinks in excel2002 won't save correctly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alastair - 24 Aug 2007 15:04 GMT

Hi All,

I'm having problems keeping hyperlink paths when i save an excel file as html.

The hyperlink works fine in excel: links to a pdf
"file:///\\server\share\folder\file.pdf" but when saved as html it is just
saved as "folder/file.pdf" I'm using the html on a webserver so need the
entire path.

I tried unselecting 'update links on exit' under tools>options>general>web
options, but still the same.

Any ideas?

Thanks in advance,

Alastair

Reply to this Message

Bill Manville - 25 Aug 2007 01:11 GMT

I don't know if it will help with this problem, but some problems with
relative links are solved by File > Properties > Summary > Hyperlink
Base : \\SomeJunkServer\JunkFolder

This forces hyperlinks to the same server as the file is saved on to be
saved as absolute.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

Alastair - 29 Aug 2007 16:20 GMT

Hi,

Thanks for your reply, unfortunately it still will not work, the HTML code
for each link still reads:

href="folder/file.pdf"

Cheers though,
Alastair.

> I don't know if it will help with this problem, but some problems with
> relative links are solved by File > Properties > Summary > Hyperlink
[quoted text clipped - 6 lines]
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Reply to this Message

Bill Manville - 30 Aug 2007 23:41 GMT

> unfortunately it still will not work, the HTML code
> for each link still reads:
>
> href="folder/file.pdf"

If you create a new hyperlink, with the hyperlink base set as I
suggested, does it come out right?
If so all we need is to fix up any existing hyperlinks which should be
possible using some code.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

Alastair - 25 Sep 2007 12:32 GMT

Cheers Bill,

With your help I've now solved the problem. I was saving the individual
sheet as html rather than the 'entire workbook'. With the hyperlink base in
place the link in html reads correctly:

<a href="file:///\\server\folder\file.pdf">file</a>

> > unfortunately it still will not work, the HTML code
> > for each link still reads:
[quoted text clipped - 9 lines]
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Reply to this Message