I created a report sheet, using the following SUMPRODUCT formula: =SUMPRODUCT((Plant=$B8)*(InvoiceDate>=U$4+1)*(InvoiceDate<=V$4)*InvoiceAmount).
The report range consists of 81 columns by 250 rows, and the above formula is copied in each cell.
It takes Excel more than a minute (timed it) to recalculate each time. I have the same experience when I copy LOOKUP (V & HLookup) formulas to a large range (One model was still recalculating after I left it on for the night).
Question: What am I doing wrong for Excel to take so long to recalculate? Excel 2003, Windows XP Professional SP3
The report range consists of 81 columns by 250 rows, and the above formula is copied in each cell.
It takes Excel more than a minute (timed it) to recalculate each time. I have the same experience when I copy LOOKUP (V & HLookup) formulas to a large range (One model was still recalculating after I left it on for the night).
Question: What am I doing wrong for Excel to take so long to recalculate? Excel 2003, Windows XP Professional SP3