formulas not working

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

Ken Wright

If hitting F9 makes it update, then try the following:-

Check Tools / Options / Calculation Tab / Set to Automatic and not Manual
 
D

David McRitchie

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0
Display weeks from a Milestone 0
Split form 0
summarizing data from various workbooks 4
Formula's won't read copy / pasted data ? 2
complicated excel formula may need an algebra wiz 1
Replace 1

Top