Ask Your Question
0

How to find out what is slowing down calc [closed]

asked 2017-02-05 12:52:00 +0100

lovecraft22 gravatar image

Dear all, I have a big calc document and for some reason, in time, it got really slow. Is there any sort of "activity monitor" which would let me understand what is causing this?

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-09-23 14:32:51.548012

Comments

1 Answer

Sort by » oldest newest most voted
1

answered 2017-02-06 00:34:24 +0100

JohnHa gravatar image

updated 2017-02-06 00:39:16 +0100

You need to trace what calculation is causing the problem.

Work with a copy of the file. Hack the spreadsheet to stop bits working; and/or delete parts of the spreadsheet; and/or if you are summing over 300 rows, cut it down to summing only two rows; etc, until you isolate the problem area.

Are you using Goal Seek? or Solver? If so, disable them.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2017-02-05 12:52:00 +0100

Seen: 84 times

Last updated: Feb 06 '17