Ask Your Question
0

How to find out what is slowing down calc

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

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

Comments

1 Answer

Sort by » oldest newest most voted
1

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

JohnHa gravatar image

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 64 times

Last updated: Feb 06 '17