SUM Function not Updating

[Guest]

Hello,

One of our business partners is having trouble w/an Excel document. They
have the SUM function used multiple times throughout the document, and as
they have changed values in certain fields, the SUM has automatically updated
itself to reflect this. It's not working anymore. I have tried to redo the
formulas but they simply won't work. The SUM stays the same regardless of
the values in the cells. I can't even create a brand new column w/the SUM
function at the bottom...it won't up date either.

In a new document I can get the SUM function to work properly, however
copying and pasting into a new document doesn't work. This is a very
extensive document and it would hours to redo it. Does anyone have any
suggestions for getting the cells to update? The document isn't protected.

Thanks,
Bobbie
is[removethispart]@nph.com

 

[Niek Otten]

Tools>Options>Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
|
| One of our business partners is having trouble w/an Excel document. They
| have the SUM function used multiple times throughout the document, and as
| they have changed values in certain fields, the SUM has automatically updated
| itself to reflect this. It's not working anymore. I have tried to redo the
| formulas but they simply won't work. The SUM stays the same regardless of
| the values in the cells. I can't even create a brand new column w/the SUM
| function at the bottom...it won't up date either.
|
| In a new document I can get the SUM function to work properly, however
| copying and pasting into a new document doesn't work. This is a very
| extensive document and it would hours to redo it. Does anyone have any
| suggestions for getting the cells to update? The document isn't protected.
|
| Thanks,
| Bobbie
| is[removethispart]@nph.com