SUMIFS with multiple criterias working slowly

[JakobL]

Hi,

I have an workbook that is really slow. I've found out that is due to a lot of sumifs with multiple(4) criterias.

The workbook contains of input-data of approx. 12000 rows of data with 50 columns.

Then there is approx. 50 different output tables with 8 rows and 12 columns. The output tables consists of the sumifs-formulas with the four different criterias. In the sumifs-formulas defined names is used, and the defined names/range refer only to the 12000 rows (not the whole column)

Don't want to use a pivot tables because I believe the pivot will not display all 8x12 fields if there is no data in some of the "cross-points". The data from the output tables is also used further in the workbook.

If I change any of the data in the input-table the workbook takes 20 seconds to "recalculate".

Any suggestions to make this workbook faster, otherwise than setting calculation options to manual?

[siddharth_s1]

Save the workbook as a csv file & reopen it in the same format.
Once you are done with your working, save it as .xls or .xlsx etc.

[JakobL]

Can't see how that could help at all? CSV-file could only save one worksheet and this file have a lot of worksheets. All data in input table is pasted in as values.