ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculate and Sum not working (https://www.excelbanter.com/excel-discussion-misc-queries/142414-calculate-sum-not-working.html)

nhall

Calculate and Sum not working
 
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.


Max

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.



All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com