We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

Calc sheet takes forever to open and save [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-05 23:13:22.800934

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

Question Tools

1 follower

Stats

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

Seen: 200 times

Last updated: Jun 03 '17