I have Excel 2007 on a 1.8 core 2 duo with buss of 1066. The workbook
contains 3 sheets that are of 1) sales from 2004 to 2006, 2) customers, and
3) current year sales. The 2004 to 2006 sales has 286,390 rows with 14
columns, customers has 607 rows, and current year sales is at 42,252 rows
with 14 columns. I use the customer sheet to compare sales by customer by
month and year to date for the previos years 2004, 2005, and 2006 to this
year's sales. I know I ask a lot of the program and computer but it takes it
15 to 17 minutes to calculate a change. I set it to manual calc and my
question is there a way to speed this up? I use sumproduct with 4 variables
and a calculation. I am relatively new to this and found out most of the
info for sumproduct() on http://www.xldynamic.com/source/xld.SUMPRODUCT.html
.. If I seperated the prior years into individual sheets of 90,000 rows would
this speed up the calc?
Thanks to all for any help or suggestions.
Lee