Group:  Microsoft Excel ยป microsoft.public.excel.links
Thread: Save Link Problem

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Save Link Problem
John Calder 31.10.2005 23:19:03
Hi

I run Windows 2000 & Excell 2000 with service pack 3.

I have an autoshape button that I have added a hyperlink to which opens a
html file on a server.

When I add the hyperlink and press the autoshape it takes me to the file ok.
I can do this as many times as I like and it works ok. The problem arises
after I save the spreadsheet. As soon as I save the spreadsheet the hyperlink
no longer works. I get the error message "The address of this site is not
valid, Check the address and try again". To add some more mystery to this, I
emailed the file to a friend and he inserted the same link to the file and it
worked ok on his machine. Now for the really strange part, he sent the file
back to me and when I open it from my email it works fine but when I save it
to anywhere on my hard drive it stops working.

The link also works fine on other office machines but not mine. Could this
be a problem with Excel itself? or even a Windows problem? or problem with a
setting somewhere?

Any help would be much appreciated

John

Re: Save Link Problem
Bill Manville <Bill-Manville[ at ]msn.com> 08.11.2005 01:27:19
Try using File / Properties and setting Hyperlink Base to some
non-existent server name like \\JunkServer\JunkDirectory

That should force the hyperlink to be held in full rather than relative
to the hyperlink base, which sometimes causes problems.

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

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net