Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
I have a formula set that I now need to double click on the formula to get it
to update. Need help. Thanks Amy |
#2
|
|||
|
|||
Hi Amy-
Formulas do not need to be double-clicked or anything else to update. As soon as you change the content of any cell that the formula looks to for a value and press Enter, the formula will automatically update to show the current result. The exception is if you have Recalculation set to Manual in your Excel Options instead of Automatic. If Recalc is set for Automatic and the formula is not updating, there is something wrong with the formula itself. First thing to check is whether the formula includes an = at the beginning. Post back with an exact copy of your formula if it still doesn't work (as well as which version of Excel). HTH |:) "AmyR" wrote: I have a formula set that I now need to double click on the formula to get it to update. Need help. Thanks Amy |
#3
|
|||
|
|||
Hi Cyber Taz
my formula is =sum(f6:f10). Everything above in this column is dollar figures, this didn't start happening until yesterday when I printed multiple worksheets at the same time. "CyberTaz" wrote: Hi Amy- Formulas do not need to be double-clicked or anything else to update. As soon as you change the content of any cell that the formula looks to for a value and press Enter, the formula will automatically update to show the current result. The exception is if you have Recalculation set to Manual in your Excel Options instead of Automatic. If Recalc is set for Automatic and the formula is not updating, there is something wrong with the formula itself. First thing to check is whether the formula includes an = at the beginning. Post back with an exact copy of your formula if it still doesn't work (as well as which version of Excel). HTH |:) "AmyR" wrote: I have a formula set that I now need to double click on the formula to get it to update. Need help. Thanks Amy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |