F9 Calc refresh does not work...
You could:
Select all the cells
Edit|Replace
what: = (equal sign)
to: = (equal sign)
replace all
LinLin wrote:
I have a spreadsheet which has some formulas which do not refresh properly.
They are simple "IF" formulas.
If I press F9 or Options / Calculate Now, they do not refresh.
They only way I can get them to work is F2 when I'm on the cell (revealing
the formula in the Formula Line) and when it closes it refreshes.
I have this formula in other sheets in the same spreadsheet but I don't have
this problem.
Any ideas?
Thanks (and happy new year to all!)
--
Dave Peterson
|