| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Try the menu choices Tools | Options | Calculation . There are several
options there for controlling recalculation of the worksheet. John www.JohnMichl.com |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get excel to automatically compute cell values | Excel Discussion (Misc queries) | |||
| How do I make formula in Excel from other worksheet? | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
| How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
| How do I make a name formula auto update in Excel | Excel Worksheet Functions | |||
Hybrid Mode
