Is there anything i can do to make it quicker?

2 thoughts:
1. Set the book to Manual calc mode (via Tools Options Calculation tab).
Then you can data-enter, etc w/o recalc getting in the way, and only press F9
to recalc after each batch of data entry is completed. Take a short break
when you press F9.
2. Edit the source ranges involved in the sumproduct. Use the smallest
possible range sizes which are just large enough to cover the possible
extent. Example, don't cover 65k rows when it highly unlikely that source
data will ever populate to that extent. Use just enough to cover. Keep ranges
smallest possible.

Above helps? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Vanessa Simmonds" wrote:
I have a big spreadsheet which is populated by sumproduct formulas.

The spreadsheet has about 173 rows and 15 columns. Every cell is populated
by at least two sumproduct formulas.

This is making the workbook extremely slow and most of the time is crashes.
Is there anything i can do to make it quicker?