Cell doesn't update automatically even when Calculations are on Au

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This problem happened once. None of my cells which had link reference to
another cell in another worksheet was updating. I had to go in there and
select then enter. I have Calculations in options on automatic. It's weird
because after I select and enter, the cells start updating bythemselves
again. Anyone experienced this or know why it happened?
 
Just an Excel hiccup.

Try this little trick to force the formulas back to formulas without select and
Enter.

Select all cells then Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP
 
Witty solution, thanks.

Gord Dibben said:
Just an Excel hiccup.

Try this little trick to force the formulas back to formulas without select and
Enter.

Select all cells then Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP
Click to expand...
 
I have never figured out when and why Excel changes formulas to text format in
this manner.

Gord
 
Back
Top