EXCEL FORMULAS

C

ColleenK

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

Bob Greenblatt

I have a spreadsheet with extensive calculations, is there any way to speed
up the calculation process?
Click to expand...
How extensive, what are the calculations, and how slow is it?
 
C

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.
 
B

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.
Click to expand...
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)
 
C

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
 
Top