Revised data fails to be used by formulas

[Richard Holbrook]

I have a spreadsheet doesnt re-calculate the formulas when
data is changed. It reacts as if I had not selected to F9
or auto to calculate. I have tried changing the
calculation option between manual and auto but neither
selection works. Manual calculation doesnt work either.
The only way to have the formula work is to select each
cell as if to edit and push enter.

Several people in my office have started having the same
problem but only on some workbooks. We all use Excel 2002
and work on a LAN.

Any Ideas?

 

[JE McGimpsey]

Were your values pasted in? Often that results in values which are
entered as Text, so some functions (e.g., SUM(), AVERAGE()) ignore them.

Try copying an empty cell, selecting your values and choose Edit/Paste
Special, and select the Values and Add radio buttons. This will coerce
any text "numbers" to numeric.