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!
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.