AutoSum

  • Thread starter Thread starter jtessier
  • Start date Start date
J

jtessier

Dear Excel users,
After years of using Excel successfully my AutoSum function ha
ceased to AutoSum well, automatically. I must recalculate everytime
wish to update a cell or close the program, when I open it up again th
cells and sums are upfdated but for some reason it no longer does thi
mid-session.
I must of clicked on some "Option" or "Protection" box but for th
life of me cannot figure it out.
This is set as an Excel Default function as all of my workbook
behave the same now.

Any help in getting this function back to normal would be greatl
appreciated.

John::confused
 
Check if you have manual calculation turned on under tools>calculations
If so change to automatic
 
I've never even been to that TAB. So simple and yet obscure. Thank yo
so much for the quick response and thank you for this excellent site.

Regards,

Joh
 
Hi John,

you are welcome..
A note about calculation manual, you only have to open a workbook set as
this as the first
and all other will get the same calculation. So if you know you haven't
tampered with it most
likely you have open another workbook or even gotten this one from someone
else..
 
Note that you can also just press "Alt =" to autosum

--
PT
Hi John,

you are welcome..
A note about calculation manual, you only have to open a workbook set as
this as the first
and all other will get the same calculation. So if you know you haven't
tampered with it most
likely you have open another workbook or even gotten this one from someone
else..
 
Back
Top