EXCEL FORMULAS

[ColleenK]

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

 

[Bob Greenblatt]

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

How extensive, what are the calculations, and how slow is it?

 

[ColleenK]

The spreadsheet is 20 meg, the formulas are sumproduct, vlookup, nested if
statements,sumif and some reference formulas. It can take up to 10 minutes
to calculate.

 

[Bob Greenblatt]

The spreadsheet is 20 meg, the formulas are sumproduct, vlookup, nested if
statements,sumif and some reference formulas. It can take up to 10 minutes
to calculate.

What version of Excel, and what version OS? In any case, if the formulas
refer to whole columns, like sumif(a:a,"xxx",b:b), it will be nuch faster if
you change the formula to refer to the used range, like:
sumif(a1:a1000,"xxx",b1:b1000)

 

[ColleenK]

Excel 2003 , XP 2002. I will try to set up the formulas the way you suggest,
as I do tend to refer to whole columns. Thank you will let you know if this
helps

 

[Mike Middleton]

ColleenK -

The top Excel calculation guru is Charles Williams. See his Optimising Speed
web pages at
http://www.decisionmodels.com/optspeedb.htm

I'm responding to the message you posted in the Macintosh Excel newsgroup
(hence the "mac" in the newsgroup name, microsoft.public.mac.office.excel).

- Mike

Email (e-mail address removed)
Web http://www.MikeMiddleton.com