excel spread sheet wont caculate new data entered in ranges.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

my excel spread sheets no longer adds new data entered in ranges. I use
Excel to track construction expenses. Recently the workbook spreadsheets
stoped adding new data entered into the ranges.
 
Tools>Options>Calculation is set to "Manual"?

The SUM range is too narrow and does not include the new data rows/columns?


Gord Dibben Excel MVP
 
Gord thanks very much. I don't know how the manual option got clicked but
that was the problem. I fiddled around checking formulas and reentering data
for a couple hours before I gave up and posted the question. So your very
correct and very quick responce is greately appreciated. Many Thanks.
 
Back
Top