What happens if you force a recalculation with F9 or with CTRL+F9?
Try Tools | Options | Calculation Tab and see if the worksheet is set to
automatically recalculate.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JENNYC" wrote in
message ...

Hi1 I have a spreadsheet that is acting up! None of my formulas are
calculating!! They are simple SUM formulas. I have 11 other identical
ones (one for ea month) & they are all working fine, so i am
confused!!?? If i retype the formulas it calculates the row, but then
when i delete the amounts it is totalling, the total still shows the
sum?? any idea how i can fix this or why this is happening? It's not an
easy sheet to replace...i have alot of other workbooks linked to this
"main" one. PLEASE HELP! :)


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile:
http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=492769