linked WorkSheets...

[AD]

Linked fields on different sheets in all my old Excel
documents have stopped updating automatically after
changes have been made! Now I have to save the document
everytime I change a value in any of the linked cells for
the changes to propagate to the linked fields throughout
the documents!?

Any newly created documents are working correctly thought.
Any ideas?

Thanks,

/AD

 

[Ken Wright]

Try Tools / Options / Calculation Tab / Set to Automatic

 

[AD]

Thanks Ken! That was easy

-----Original Message-----
Try Tools / Options / Calculation Tab / Set to Automatic

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

---------------------------------------------------------- ------------------
It's easier to beg forgiveness than ask permission
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004


.

 

[Ken Wright]

What's probably happening is that a file you open regularly first time you
launch Excel has been set to manual. The setting in the first workbook you open
once you launch Excel sets the scene for the rest of the day unless you manually
change this setting as you just did. Perhaps a timecard sheet or a to do list?
Find it, change the setting and save it.