Pausing formula evaluations in Excel 2007

  • Thread starter Thread starter Nils Magnus
  • Start date Start date
N

Nils Magnus

Hello, I'm working in a quite large Excel document with rather
resource-intensive formulae. I want to be able to first enter all the
input values before I start the evaluation - otherwise, I would have to
wait around 60 seconds between each field I enter data in.

Is it possible to pause the evaluation of the Excel workbook with some
sort of toggle switch, so I can enter the values before the evaluation
continues?


Regards,
Nils Magnus
 
Hi,

You can set the calculation to manual, then hit F9 key when you want to
re-calculate!

Regards!
Jean-Guy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Might be a bug in Evaluate Formula? 2
Formula Audit mode active in one column only; cannot kill. 2
Excel won't resolve formula in one column 3
Countif wrong in last row or two 3
IF Statement evaluating Dates and Weekdays 5
evaluating text as if it were a formula 2
SUMIF formula works in Excel 2003, does not work in Excel 2007 3
Formula for evaluating predictions - Fantasy Football League 8

Back
Top