AutoCalculate appears disabled - how enable??
 

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!

AutoCalculate appears disabled - how enable??
 

Tools - Options - Calculations (tab) - Auto Calculate
--
HTH...

Jim Thomlinson


"ALOTT5K" wrote:

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!

AutoCalculate appears disabled - how enable??
 

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.

"ALOTT5K" wrote:

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!