View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Calculate and Sum not working

Sounds like the calc mode's set "inadvertently" to Manual. Check/ensure the
calc mode's set to Auto. Click Tools Options Calculation tab. Options are
there
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"nhall" wrote:
After I insert a function, normally when I add another amount it
automatically sums it up. It dose not do that now. I have to reinsert a
function every time I need to see the calculated total. The majority of my
work day revolves around excel and using the functions. Please help me.