Ask Your Question
0

Calc sheet takes forever to open and save

asked 2017-06-02 23:08:47 +0200

lovecraft22 gravatar image

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!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-06-03 16:13:30 +0200

lovecraft22 gravatar image

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

edit flag offensive delete link more

Comments

Pls where's the sumif?

m.a.riosv gravatar imagem.a.riosv ( 2017-06-04 14:42:22 +0200 )edit
0

answered 2017-06-03 13:39:42 +0200

m.a.riosv gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-06-02 23:08:47 +0200

Seen: 106 times

Last updated: Jun 03 '17