View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default sum formulas not updating

ToolsOptionsCalculation tab, check Automatic

If that doesn't help, check this list:

http://xldynamic.com/source/xld.xlFAQ0024.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Office_Novice" wrote in message
...
|I have an issue with sum formulas not updating for new info in the range
| cells? It looks PC specific, but I don't know how to check the problem. Ant
| help wpuld be great.
|