Question

Locked

deactivate links in excel 2007

By gmwt ·
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?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Solution

by daitau In reply to deactivate links in excel ...

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

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums