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

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