Excel 2003 behavior

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jacques trepanier - 02 Nov 2006 21:48 GMT

Hello,

When we open an Excel 2002 spreadsheet with Excel 2003 (running on XP) the
spreadsheet is recalculated to be optimized for Excel 2003. If some cells
have links to outside data (on other spreadsheet we don`t have) this causes
problems.

Is there a way around this automatic feature of Excel 2003 ? Can it be
disabled ?

Regards,

Signature

Jacques Trepanier

Reply to this Message

Dave Peterson - 02 Nov 2006 22:45 GMT

Jim Rech posted a registry tweak:
http://groups.google.com/groups?threadm=uzkujhMHEHA.3284%40TK2MSFTNGP11.phx.gbl

> Hello,
>
[quoted text clipped - 9 lines]
> --
> Jacques Trepanier

Signature

Dave Peterson

Reply to this Message

Jacques Trépanier - 02 Nov 2006 23:13 GMT

Dave,

This works great! Thanks to you and Jim!

Best Regards,

> Jim Rech posted a registry tweak:
> http://groups.google.com/groups?threadm=uzkujhMHEHA.3284%40TK2MSFTNGP11.phx.gbl
[quoted text clipped - 14 lines]
>> --
>> Jacques Trepanier

Reply to this Message

Gord Dibben - 02 Nov 2006 22:51 GMT

Tools>Options>Edit. Uncheck "ask to update automatic links"

Or maybe better just go to Edit>Links and delete the non-existent workbook from
the list by "break links".

Gord Dibben MS Excel MVP

>Hello,
>
[quoted text clipped - 7 lines]
>
>Regards,

Reply to this Message