Formula bar needing refreshing ??
 

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

Formula bar needing refreshing ??
 

Maybe you're not in automatic calculation mode.

In xl2003 menus:
tools|Options|calculation tab
(make it automatic)



Steve wrote:

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

--

Dave Peterson

Formula bar needing refreshing ??
 

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" wrote:

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

Formula bar needing refreshing ??
 

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" wrote:

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" wrote:

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

Formula bar needing refreshing ??
 

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.

Steve wrote:

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" wrote:

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" wrote:

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




--

Dave Peterson

Formula bar needing refreshing ??
 

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" wrote:

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.

Steve wrote:

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" wrote:

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" wrote:

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




--

Dave Peterson
.

Formula bar needing refreshing ??
 

I've never seen this in real life, but lots of people have posted with the same
problem that you wrote about.

Steve wrote:

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" wrote:

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.

Steve wrote:

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" wrote:

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" wrote:

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




--

Dave Peterson
.


--

Dave Peterson