STOP Auto Calculate

  • Thread starter Thread starter EngelseBoer
  • Start date Start date
E

EngelseBoer

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
 
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.
 
thanks

bpeltzer said:
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.
Click to expand...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet Names and Auto-calculation 2
The next Grand Theft Auto title has been officially announced 0
Calculating When Somebody Reaches a Certain Age 4
manual calculate 5
Can I use Dynamic Ranges to automate complex calculations? 5
Switch calculating cells off 2
Restart Windows - now stuck 6
How to stop the auto-format of dates? 5

Back
Top