Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
STOP Auto Calculate
is there a way to STOP this blasted thing for Auto Cal till i am ready
i make 1 small change and have to wait ages before i can continue... PLEASE SOMEBODY |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
STOP Auto Calculate
toolsoptionscalculation set to manual
-- Regards, Peo Sjoblom "EngelseBoer" wrote in message ... is there a way to STOP this blasted thing for Auto Cal till i am ready i make 1 small change and have to wait ages before i can continue... PLEASE SOMEBODY |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
STOP Auto Calculate
You can turn it off; the exact steps depend on which version of Excel you're
using. In 2007, click the Office Button, then Excel Options and Formulas. In earlier versions, I think it's Tools, Options, Calculation... In either case, you'll then select 'Manual'. Then change it back when you're done, or just hit 'F9' to recalc while you're working. "EngelseBoer" wrote: is there a way to STOP this blasted thing for Auto Cal till i am ready i make 1 small change and have to wait ages before i can continue... PLEASE SOMEBODY |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
STOP Auto Calculate
YESSSSSSSSSSSSS
Thank you Peo "Peo Sjoblom" wrote: toolsoptionscalculation set to manual -- Regards, Peo Sjoblom "EngelseBoer" wrote in message ... is there a way to STOP this blasted thing for Auto Cal till i am ready i make 1 small change and have to wait ages before i can continue... PLEASE SOMEBODY |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
STOP Auto Calculate
thanks
"bpeltzer" wrote: You can turn it off; the exact steps depend on which version of Excel you're using. In 2007, click the Office Button, then Excel Options and Formulas. In earlier versions, I think it's Tools, Options, Calculation... In either case, you'll then select 'Manual'. Then change it back when you're done, or just hit 'F9' to recalc while you're working. "EngelseBoer" wrote: is there a way to STOP this blasted thing for Auto Cal till i am ready i make 1 small change and have to wait ages before i can continue... PLEASE SOMEBODY |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
STOP Auto Calculate
Hi,
Can you tell me how can I set it to "Manual" Calc setting by default when I open Excel and Book1? Thanks in advance. "EngelseBoer" wrote: thanks "bpeltzer" wrote: You can turn it off; the exact steps depend on which version of Excel you're using. In 2007, click the Office Button, then Excel Options and Formulas. In earlier versions, I think it's Tools, Options, Calculation... In either case, you'll then select 'Manual'. Then change it back when you're done, or just hit 'F9' to recalc while you're working. "EngelseBoer" wrote: is there a way to STOP this blasted thing for Auto Cal till i am ready i make 1 small change and have to wait ages before i can continue... PLEASE SOMEBODY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate how much time falls between set start and stop times | Excel Worksheet Functions | |||
Excel 2002: Formulas stop calculate correctly after 13.4MB | Excel Discussion (Misc queries) | |||
how do i stop the auto format on excel? | Excel Discussion (Misc queries) | |||
How do I get Excel to stop auto-formatting? | Excel Discussion (Misc queries) | |||
can't stop auto fomatting - help | Excel Discussion (Misc queries) |