| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formulas
I have a spreadsheet with extensive calculations, is there any way to speed
up the calculation process? -- CK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
See if articles are of any help:
http://www.decisionmodels.com/calcsecretsc.htm#Calc_Seq http://msdn.microsoft.com/en-us/library/aa730921.aspx -- Thx MSweetG222 "ColleenK" wrote: I have a spreadsheet with extensive calculations, is there any way to speed up the calculation process? -- CK |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
Thanks for the information, unfortunately, it has not helped, it seems that
the biggest problem is the "File Save", it is taking over 20 minutes. -- CK "MSweetG222" wrote: See if articles are of any help: http://www.decisionmodels.com/calcsecretsc.htm#Calc_Seq http://msdn.microsoft.com/en-us/library/aa730921.aspx -- Thx MSweetG222 "ColleenK" wrote: I have a spreadsheet with extensive calculations, is there any way to speed up the calculation process? -- CK |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
Do you need to "calc" before you save? If not, set calc mode to "manual" and
turn off the "re-calc on save" option under Tools | Options | Calculation. Of course, this only works if you do not need to calc the workbook before the save. Sorry I was not more help. -- Thx MSweetG222 "ColleenK" wrote: Thanks for the information, unfortunately, it has not helped, it seems that the biggest problem is the "File Save", it is taking over 20 minutes. -- CK "MSweetG222" wrote: See if articles are of any help: http://www.decisionmodels.com/calcsecretsc.htm#Calc_Seq http://msdn.microsoft.com/en-us/library/aa730921.aspx -- Thx MSweetG222 "ColleenK" wrote: I have a spreadsheet with extensive calculations, is there any way to speed up the calculation process? -- CK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| Excel formulas | Excel Discussion (Misc queries) | |||
Linear Mode
