Excel 2003 behavior

[Jacques trepanier]

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,

 

[Dave Peterson]

Jim Rech posted a registry tweak:
http://groups.google.com/[email protected]

 

[Gord Dibben]

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

 

[Jacques Trépanier]

Dave,

This works great! Thanks to you and Jim!

Best Regards,