How to make excel not to compute formula
 

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


--
anoopra
------------------------------------------------------------------------
anoopra's Profile: http://www.excelforum.com/member.php...o&userid=26686
View this thread: http://www.excelforum.com/showthread...hreadid=399587

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

John
www.JohnMichl.com

anoopra Wrote:
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

Hi Anoop

Try Tools Options calculation Tab, switch calculation from
Automatic to Manual, to calculate when ready you can use the F9 key


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399587

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!
================================================== ===

"anoopra" wrote in
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


--
anoopra
------------------------------------------------------------------------
anoopra's Profile:
http://www.excelforum.com/member.php...o&userid=26686
View this thread: http://www.excelforum.com/showthread...hreadid=399587