New numbers not included in totals

C

Carole O

I don't know what is happening - but I have several columns with sum(A2:A13,
B2...)in row 14. When I enter data for the next month within A, Row 14 does
not change. If I enter =sum(a2:a13) in another cell (row 16, for instance),
it totals all the cells. But - if I enter numbers in another cell in row A,
neither row 14 or 16 reflects the additional data to summarize.

The only thing I've done is added Chip Pearson's Rowliner.

TIA,

Carole O
 
C

Carole O

You are wonderful!! Thank you. Now all I have to do is figure out which
gremlin changed the setting!!

Carole O
 
F

Frank Kabel

Hi
this is an application level setting. The first opened workbook
determines the setting for the other ones. So maybe you opened such a
workbook
 
Top