View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default why don't my totals change when I enter additional data?

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten

"Melozia" wrote in message ...
|I have to click on the formula, re-enter a digit (any one) and then hit eter
| for my totals to be current after inputting additonal data.