formulas not working

  • Thread starter Thread starter keirsten
  • Start date Start date
K

keirsten

My formulas are correct and reference the appropriate
cells, but when I enter data to the referenced cells the
formulas do not calculate a value. This is occuring on
several of my spreedsheets.
 
If hitting F9 makes it update, then try the following:-

Check Tools / Options / Calculation Tab / Set to Automatic and not Manual
 
Additional things to check:

If you see the formulas you may be in formula view
Tools, Options, View, ...
or you may have space or other characters at beginning of cell
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

If F9 does not work there is a super duper recalculation.
Ctrl+Alt+F9
and if that is the problem you likely have UDF (User Defined Functions)
that do not include the address of the changed cell(s) it is dependent upon.

Shortcut Keys in Excel 2000 (Excel Vers. 9)
Location: http://www.mvps.org/dmcritchie/excel/shortx2k.htm--
 
Back
Top