View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default excel spread sheet wont caculate new data entered in ranges.

ToolsOptionsCalculation is set to "Manual"?

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


Gord Dibben Excel MVP

On Mon, 7 Nov 2005 14:05:04 -0800, "Art-needs-help"
wrote:

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.