Ask Your Question
0

Cancel manual recalculation? [closed]

asked 2014-07-03 14:50:20 +0200

Stratos Nikolaidis gravatar image

Hello from Malta! In a huge sheet I'm working no, I have disabled the cell autocalculation, so whenever I need an update, I press F9 and the sheet recalculates everything.

In can we want to cancel the recalculation, what can we do? In large files with thousands or lines and formulas etc, each recalculation might take 5-10 minutes.

I don't know if there's any feature like this but imo, there should be. It's not easy to wait 5 and 10 minutes, just because of an error in a formula.

Thank you in advance!

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 2016-02-27 12:10:27.957149

1 Answer

Sort by » oldest newest most voted
0

answered 2014-07-03 16:11:22 +0200

m.a.riosv gravatar image

As I know not, maybe such feature could leads to take even more time in the recalculation.

Perhaps there is something what can be done to reduce calculation time.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-07-03 14:50:20 +0200

Seen: 54 times

Last updated: Jul 03 '14