problem when linking to another excel document ...

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

[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 wrote:
>
> 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??

--

Dave Peterson

[T-Quest]

it works!
thanks very much for the tip!
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
>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 wrote:
>>
>> 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??
>
> --
>
> Dave Peterson