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

J

J@Y

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

Gord Dibben

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
 
J

J@Y

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

Gord Dibben

I have never figured out when and why Excel changes formulas to text format in
this manner.

Gord
 
Top