Excel 2K calculation problem...

I have a user who says that, on occasion, when she puts in numbers for a simple calculation, like SUM, when she goes to sum them the formula doesn't work. There's nothing wrong with the formula. I've checked and re-checked. The formula is fine. I've checked in Tools>>Options and the file is set to calculate automatically.

When I opened the file up on my PC it acted the same way, but when I re-entered the values into the appropriate fields the calculation kicked in and worked properly. Any idea what's causing this and how to fix it?

 

Are you trying to calculate the values on a field that has a formula in it as opposed to a numeric value?

 

it's setup like this. there are 4 columns and 5 rows. column D has the values in it. so the values are in d1 thru d4, with the calculation being in d5. so the function is supposed to calculate the values in d1-d4 - =sum(d1:d4) - and it's not working unless you re-enter the values. hope this helps and thx for teh quick response.

 

Are there values in A5 - D5? or is that a blank row and just D5 does the calculation? Look at the formulas in D1-D4....do they correspond correctly to the row they are associated with or not.

 

the only values are in column D, d1-d4. The rest are filled with text for descriptive purposes. Kinda like this:

blah blah blah 5
blah blah blah 27
blah blah blah 108
blah blah blah 43
total =sum(d1:d4)