Software

Ask something
Question Locked

deactivate links in excel 2007

0 helpful
2 replies

by gmwt

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In excel 2003 when I opened an excel book , I got a quesion if I want to activate the links to other excel books. If my answer was no I got the old values in the excel book.
I installed excel 2007 and no matter how I configue the book behavior I got "REF" error on broken links.
I need the old values and I do not want to correct the broken links.
How can I configure it?

2 replies

by daitau

Try to add the following registry key:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options]
"FullCalcOnLoadOldFile"=dword:00000000

This discussion is closed to new replies.