Hi there I have put a template together which is now 1.66mb, the workbook is
huge with one tab "Entry Form" and the other "Project Costs", then there are
a few reports based on the calculations in Project Costs.

I have monthly budget, actual and forecast for 5 years across the project
costs tab, with columns for project stages, workstreams, departments, Expense
type and resources name, etc. All these informations are brought into the
reporting tabs and i use sumproducts to look for the year, the month, the
workstream, expense type and project stage: my formula is as follow:

=SUMPRODUCT(--($A$38='Project Costs'!$A7:$A65536)*--($A$2='Project
Costs'!$L$7:$L$65536)*--(B$38='Project Costs'!$CJ$6:$EQ$6),'Project
Costs'!$CJ$7:$EQ$65536)/1000

This formula is on every report tabs (currently 4) as the project manager
wants to see spendings on different project stage and each worksteams under
the project stages.

It takes over 10 mins to calculate, and sometimes it crashes. What can I do
to reduce the time for it to calculate? I've tried the turning off the
calculate automatically option, but still when it's refresehed or saved, the
problem comes back. Any suggestions? Thanks a lot!!