Cells not updating
 

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.

Cells not updating
 

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.

Cells not updating
 

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.

Cells not updating
 

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.

Cells not updating
 

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.