problem when linking to another excel document ...

  • Thread starter Thread starter Dave Peterson
  • Start date Start date
D

Dave Peterson

I don't have a guess why excel crashes when you use a hyperlink, but a couple
people have posted that if they change the hyperlink base
(file|properties|summary tab) to c:\, then the path isn't changed.

I like to use the worksheet function =hyperlink() to create them.

You may want to try that if you don't find a solution to the crashing.

Good luck,

ps. If you do find the cause, please post back. Then google will have for the
next person.
 
Im' in excel 2003, with all office updates installed.
When I create a new (or existing) excel sheet, I try to add a hyperlink to a
regular word like 'test' which is typed into a cell.
This works when I link to a txt file, but excel crashes when I link to a xls
file!!
It does work when i DONT save, but when I save the document, I can't click
the link anymore .... .

sometimes excel saves the link like this:
\\server\Data\data.xls

or sometimes it saves the link like this:
...\..\data.xls

both ways excel crashes.

I tested this on 3 pc's on dofferent locations/companys.

Anybody knows a solution??
 
it works!
thanks very much for the tip!
Dave Peterson said:
I don't have a guess why excel crashes when you use a hyperlink, but a
couple
people have posted that if they change the hyperlink base
(file|properties|summary tab) to c:\, then the path isn't changed.

I like to use the worksheet function =hyperlink() to create them.

You may want to try that if you don't find a solution to the crashing.

Good luck,

ps. If you do find the cause, please post back. Then google will have
for the
next person.
Click to expand...
 
Back
Top