How to make excel not to compute formula

[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

 

[John Michl]

Try the menu choices Tools | Options | Calculation . There are several
options there for controlling recalculation of the worksheet.

John
www.JohnMichl.com

 

[Paul Sheppard]

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

Hi Anoop

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

 

[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