Excel Formulas
 

I have a spreadsheet with extensive calculations, is there any way to speed
up the calculation process?
--
CK

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

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

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