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.

HI Ron
You are most likely set on manual calculation.
Goto . ToolsOptionsCalculations = set it to Automatic not manual.
HTH
John
"RonJr" wrote in message
...
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.

hi
contrary to popular believe, excel was not designed by God.
Being of human origin, it does "hiccup" now and then.
2003...check ToolsoptionsCalculation Tab....
make sure your are set to automatic and not manual.

Regards
FSt1

"RonJr" wrote:

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.

Thanks, John. Wonder how it got toggled over after 1.5 years of use?

"John" wrote:

HI Ron
You are most likely set on manual calculation.
Goto . ToolsOptionsCalculations = set it to Automatic not manual.
HTH
John
"RonJr" wrote in message
...
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.

You're welcome
John
"RonJr" wrote in message
...
Thanks, John. Wonder how it got toggled over after 1.5 years of use?

"John" wrote:

HI Ron
You are most likely set on manual calculation.
Goto . ToolsOptionsCalculations = set it to Automatic not manual.
HTH
John
"RonJr" wrote in message
...
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.