Updatings Links to Data nad Formulas

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

Yikes, I have know idea what caused this to change. When I enter new data into
any cell that has links to it via formulas the destinations cells don't change
until I save the file. This was never the case before, they would always
update right after I typed in the new data and hit enter.

Does anyone know what setting controls this????

Thanx...

Dennis
 
On the menu bar select:
Tools / Options / Calculations
Check 'Automatic'

-----Original Message-----
Yikes, I have know idea what caused this to change. When I enter new data into
any cell that has links to it via formulas the
Click to expand...
destinations cells don't change
 
Back
Top