Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

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.

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

Related Discussions

Related Forums