problem when linking to another excel document ...

[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.

 

[T-Quest]

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??

 

[T-Quest]

it works!
thanks very much for the tip!

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.