I have put in formula to total a column of figures, it has empty cells for
new items to be entered as they occur. It used to total in new items
automatically, now it will not total in new items. It is a Monthly
spreadsheet. I used" create a copy "to make blank copies to use for following
months. I made changes to existing sheets as I needed to by using CTRL key
and clicked on each future month. this may be why it will not total as new
figures are added.