| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Needing to know what formula to use | Excel Worksheet Functions | |||
| needing a formula i think? | New Users to Excel | |||
| Needing a formula | Excel Discussion (Misc queries) | |||
| NEEDING FORMULA Please | Excel Worksheet Functions | |||
| Needing to know how to use a "and" in a formula.... | Excel Worksheet Functions | |||
Hybrid Mode
