Thread: hyperlinks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default hyperlinks

Some people have posted that changing the hyperlink base property helps.

File|properties|summary tab
change it something like:
c:\



Christopher wrote:

Hello all,

Maybe someone has seen this problem before.
I've used a hyperlink in an excel cell to refer to a file that is located on
a server.
An example: "//server/directory1/directory2/directory3/the file that is
linked.pdf"

When I then click on the hyperlink the "pdf-file" is opened. So, no problem
there.
When I save the sheet an re-open it the hyperlink is changed to:
"//../../../directory3/the%20file%20that%20is%20linked.pdf"
When I now click on the hyperlink the "pdf-file" can not be located anymore
and thus can not be opened.

The excel file is also located on the server.
The strange part now is that when I open the excel file on another computer
in the network and click on the hyperlink the link does work without a
problem.

All systems are running Windows 2000 with Office 2000.

Does anyone have an idea what is wrong here.

Thanks,
Christopher


--

Dave Peterson