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!

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!

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!