Formula bar needing refreshing ??

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I not sure how to put this, but I have formulas that aren't working until I
'refresh??' them.
Here's one of thr
formulas:=IF('Rollup'!G15-'Rollup-prior'!G15<>0,'Rollup'!G15-'Rollup-prior'!G15,"")

Basically, if I change the G15 data, the result of the formula doesn't
change until I place the cursor in front of the = in the formula bar,then hit
enter. When I do that, the formula works.

Thanks,

Steve
 
Maybe you're not in automatic calculation mode.

In xl2003 menus:
tools|Options|calculation tab
(make it automatic)
 
Sounds like Calculate is set to manual.
Excel 2003 and earlier:
Tools --> Options -->[Calculation] tab and make sure Automatic is selected.
Excel 2007+
Office-Button, then [Excel Options] button (lower right of dialog), then
Formulas group and at the top is the Calculation Options, again make sure
Automatic is selected.
 
It is set to automatic. It is a rather large file ( 17,500 KB), containing
quite a few of fairly lengthy formulas ( mainly thanks to a lot of help and
assistance from this discussion group.) Everything else seems to be always
working ok, except for this particular situation.
This was after working on Excel most of the day, so yesterday I also did a
shutdown and restart, thinking maybe I had to purge some memory, but it
didn't fix the problem, however, today, first think in the morning, it seems
to be working properly.

Any thoughts,

JLatham said:
Sounds like Calculate is set to manual.
Excel 2003 and earlier:
Tools --> Options -->[Calculation] tab and make sure Automatic is selected.
Excel 2007+
Office-Button, then [Excel Options] button (lower right of dialog), then
Formulas group and at the top is the Calculation Options, again make sure
Automatic is selected.

Steve said:
I not sure how to put this, but I have formulas that aren't working until I
'refresh??' them.
Here's one of thr
formulas:=IF('Rollup'!G15-'Rollup-prior'!G15<>0,'Rollup'!G15-'Rollup-prior'!G15,"")

Basically, if I change the G15 data, the result of the formula doesn't
change until I place the cursor in front of the = in the formula bar,then hit
enter. When I do that, the formula works.

Thanks,

Steve
Click to expand...
Click to expand...
 
Try selecting a single cell on the offending sheet.
Edit|Replace
what: = (an equal sign)
with: =
replace all

Excel will see this as a change to all the formulas and reevaluate them. Then
try testing again. It may have woken up excel calculation engine.
It is set to automatic. It is a rather large file ( 17,500 KB), containing
quite a few of fairly lengthy formulas ( mainly thanks to a lot of help and
assistance from this discussion group.) Everything else seems to be always
working ok, except for this particular situation.
This was after working on Excel most of the day, so yesterday I also did a
shutdown and restart, thinking maybe I had to purge some memory, but it
didn't fix the problem, however, today, first think in the morning, it seems
to be working properly.

Any thoughts,

JLatham said:
Sounds like Calculate is set to manual.
Excel 2003 and earlier:
Tools --> Options -->[Calculation] tab and make sure Automatic is selected.
Excel 2007+
Office-Button, then [Excel Options] button (lower right of dialog), then
Formulas group and at the top is the Calculation Options, again make sure
Automatic is selected.

Steve said:
I not sure how to put this, but I have formulas that aren't working until I
'refresh??' them.
Here's one of thr
formulas:=IF('Rollup'!G15-'Rollup-prior'!G15<>0,'Rollup'!G15-'Rollup-prior'!G15,"")

Basically, if I change the G15 data, the result of the formula doesn't
change until I place the cursor in front of the = in the formula bar,then hit
enter. When I do that, the formula works.

Thanks,

Steve
Click to expand...
Click to expand...
Click to expand...
 
Thank you. That's a nice trick. I'll definitely give it a try if &/or when it
acts up again.
I guess Excel is so complex, that weird things do happen once in a while.
Thanks again,

Steve

Dave Peterson said:
Try selecting a single cell on the offending sheet.
Edit|Replace
what: = (an equal sign)
with: =
replace all

Excel will see this as a change to all the formulas and reevaluate them. Then
try testing again. It may have woken up excel calculation engine.
It is set to automatic. It is a rather large file ( 17,500 KB), containing
quite a few of fairly lengthy formulas ( mainly thanks to a lot of help and
assistance from this discussion group.) Everything else seems to be always
working ok, except for this particular situation.
This was after working on Excel most of the day, so yesterday I also did a
shutdown and restart, thinking maybe I had to purge some memory, but it
didn't fix the problem, however, today, first think in the morning, it seems
to be working properly.

Any thoughts,

JLatham said:
Sounds like Calculate is set to manual.
Excel 2003 and earlier:
Tools --> Options -->[Calculation] tab and make sure Automatic is selected.
Excel 2007+
Office-Button, then [Excel Options] button (lower right of dialog), then
Formulas group and at the top is the Calculation Options, again make sure
Automatic is selected.

:

I not sure how to put this, but I have formulas that aren't working until I
'refresh??' them.
Here's one of thr
formulas:=IF('Rollup'!G15-'Rollup-prior'!G15<>0,'Rollup'!G15-'Rollup-prior'!G15,"")

Basically, if I change the G15 data, the result of the formula doesn't
change until I place the cursor in front of the = in the formula bar,then hit
enter. When I do that, the formula works.

Thanks,

Steve
Click to expand...
Click to expand...
Click to expand...
 
I've never seen this in real life, but lots of people have posted with the same
problem that you wrote about.
Thank you. That's a nice trick. I'll definitely give it a try if &/or when it
acts up again.
I guess Excel is so complex, that weird things do happen once in a while.
Thanks again,

Steve

Dave Peterson said:
Try selecting a single cell on the offending sheet.
Edit|Replace
what: = (an equal sign)
with: =
replace all

Excel will see this as a change to all the formulas and reevaluate them. Then
try testing again. It may have woken up excel calculation engine.
It is set to automatic. It is a rather large file ( 17,500 KB), containing
quite a few of fairly lengthy formulas ( mainly thanks to a lot of help and
assistance from this discussion group.) Everything else seems to be always
working ok, except for this particular situation.
This was after working on Excel most of the day, so yesterday I also did a
shutdown and restart, thinking maybe I had to purge some memory, but it
didn't fix the problem, however, today, first think in the morning, it seems
to be working properly.

Any thoughts,

:

Sounds like Calculate is set to manual.
Excel 2003 and earlier:
Tools --> Options -->[Calculation] tab and make sure Automatic is selected.
Excel 2007+
Office-Button, then [Excel Options] button (lower right of dialog), then
Formulas group and at the top is the Calculation Options, again make sure
Automatic is selected.

:

I not sure how to put this, but I have formulas that aren't working until I
'refresh??' them.
Here's one of thr
formulas:=IF('Rollup'!G15-'Rollup-prior'!G15<>0,'Rollup'!G15-'Rollup-prior'!G15,"")

Basically, if I change the G15 data, the result of the formula doesn't
change until I place the cursor in front of the = in the formula bar,then hit
enter. When I do that, the formula works.

Thanks,

Steve
Click to expand...
Click to expand...
Click to expand...
 
Back
Top