Excel stops adding

[digitaltammi]

Hi,

This one is a bit hard to explain, but I'll do my best. I've got this
Excel document that has a number of formulas. I've got the contents of
column A adding up. If I change one of the numbers in column A, the
total doesn't change. If I copy the formula from column A over to
column B, the total of column A is displayed in column B.

This only seems to happen when I work in this one particular document
and seems to affect Excel globally if I open a brand new document after
I've used this "bad" document until I quit Excel. If I quit Excel and
start a new document, the formulas work properly... until I use the
"bad" document.

What could be causing this? I'm using Excel X 10.1.4.

 

[Bernard Rey]

digitaltammi :

This one is a bit hard to explain, but I'll do my best. I've got this
Excel document that has a number of formulas. I've got the contents of
column A adding up. If I change one of the numbers in column A, the
total doesn't change. If I copy the formula from column A over to
column B, the total of column A is displayed in column B.

This only seems to happen when I work in this one particular document
and seems to affect Excel globally if I open a brand new document after
I've used this "bad" document until I quit Excel. If I quit Excel and
start a new document, the formulas work properly... until I use the
"bad" document.

This reads pretty similar to the message "MikeB" wrote last Tuesday. I guess
John McGimpsey's solution should work for you too:

Preferences/Calculation, click Automatic.

Does it?

 

[CyberTaz]

Can't remember X specifics, but if you go to Excel Preferences & take a
look at the Calculations page while you have that file open, Select
'Automatic' rather than 'Manual'. Then make a minor change, undo the
change & save the file.

That should resolve it _unless_ there is some sort of custom code
involved that is changing the recalc prefs when the file opens.

HTH |:>)

 

[digitaltammi]

Thanks all. I should have mentioned... I saw that post from last week.
The Calculations Preferences are not the culprit. I wish it were that
simple. We're ditching the "bad" file for now. I was just wondering if
anyone's heard of this happening before.

 

[JE McGimpsey]

What could be causing this? I'm using Excel X 10.1.4.

Without seeing the formula, the only guess I could make is that the
file's corrupt.

 

[CyberTaz]

As implied in JE's reply, how about copying the formula & pasting it
into a new post in this thread?

Regards |:>)

 

[mbumark]

Check to see if calculation is set for manual or automatic -- with the
problematic document open, choose Excel then Preferences, click the
Calculation tab, -- ensure that the Automatic option button is enabled.