Calc sheet takes forever to open and save

[lovecraft22]

Dear all,
I have a Calc sheet which takes a lot to open and especially to save (1’40").

My questions are:

1. Any way to improve the saving time?
2. Any way to check what is causing the slowdown? Some sort or activity monitor or something…
3. What slows down calc the most: conditional formatting, formula, conditional formula (sumifs) done on entire columns

Thanks!

[mariosv]

Not easy without a file, but maybe you have a conditional format for every cell instead only one for the whole range.

Conditional format it’s recalculated for every change on the sheet, so having it well defined helps to speed up the spreadsheet.

Please can you share a sample file.

[lovecraft22]

Hi,
I have been able to identify the issue. Among others, in my file I have lots of sumifs such as:
=IF($M$1>=J2;(IF($M$1<=N2;L2/DAY($M$1)*DAYSINMONTH(J2);L2));0)

Now, these appear to be the culprit. Is there any workaround for this?

Thanks

[mariosv]

Pls where’s the sumif?