linked WorkSheets...

  • Thread starter Thread starter AD
  • Start date Start date
A

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
 
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


.
Click to expand...
 
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.
 
Back
Top