Help! I keep a workbook that I update nearly daily. Just recently, I've
noticed that as I add numerical data, the cells that have functions (SUM
mostly) are not automatically updating to reflect new totals. For example,
B1 holds SUM(A:A). When I add new data in column A, then number in B1 does
not change unless I select B1, click on the formula bar and hit enter.