AutoCalculate appears disabled - how enable??

  • Thread starter Thread starter ALOTT5K
  • Start date Start date
A

ALOTT5K

My autocalculate on my worksheets do not work for cells in a column, row or
group of cells selected. it only displays the greatest value in the group of
cells.

How do I enable the autocalculate or fix this problem on my worksheets?

Thank you for your help!
 
The number that appears on the right side of the status bar when one or more
value cells are selected can be a sum, an average, a max, a min, or a count.
It sounds like yours is set to max. simply right click that portion of the
status bar and a menu will appear from which you can select sum.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Editing a formula 11
Excel 2003 status bar autocalculate resize the width 1
AutoCalculate doesn't see my data 1
Worksheet autocalc with min function in error 2
About the autocalculate in the status bar... 3
Calculate text 1
Command Button / Macro won't execute properly 4
Cell updates not occuring 11

Back
Top