How to make excel not to compute formula

A

anoopra

Hi,
I have a workbook filled with formulas and it takes time to compute
formula and open the workbook.

Is there a way I can stop the computation of formula when the workbook
is opened?
Is there a way to start the computation of formulas?

Thanks in advance.

Regards,
Anoop
 
P

Paul Sheppard

anoopra said:
Hi,
I have a workbook filled with formulas and it takes time to comput
formula and open the workbook.

Is there a way I can stop the computation of formula when the workboo
is opened?
Is there a way to start the computation of formulas?

Thanks in advance.

Regards,
Anoop
Click to expand...

Hi Anoop

Try Tools > Options > calculation Tab, switch calculation fro
Automatic to Manual, to calculate when ready you can use the F9 ke
 
R

RagDyeR

After you set your calculation mode to "Manual",
You can calculate you sheets separately, one at a time, by using
<Shift> <F9>
Which will *only* calculate the sheet that's selected.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
Hi,
I have a workbook filled with formulas and it takes time to compute
formula and open the workbook.

Is there a way I can stop the computation of formula when the workbook
is opened?
Is there a way to start the computation of formulas?

Thanks in advance.

Regards,
Anoop
 
Top