• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 114
  • Last Modified:

Excel 2010 - How to break when Excel calculates formula too long

Dear Experts,

Before of the question I would like to confirm, that I need these 'Automatic calculation' settings on the picture in Excel for my daily work and that is set:
Settings
But could you please advise with some tips, how to stop Excel when calculates too long a formula?

I have tried pressing ESC, or Ctrl - Break, they did not help, only the Ctrl - Alt - Del and closing Excel, but that is not too practical

Thanks in advance,
0
csehz
Asked:
csehz
  • 2
2 Solutions
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Also if you have lots of formulas on the sheet, it's better to set the calculation options to manual.
And you may use F9 ( to calculate all the worksheets in all the open workbooks) or Shift+F9 to calculate the Activesheet only.
0
 
Saqib Husain, SyedEngineerCommented:
Excel calculation can be interrupted by continuing to work on the spreadsheet. When you stop editing the recalculation resumes automatically. For detailed explanation see:

http://www.dummies.com/how-to/content/how-to-control-formula-recalculation-in-excel-2013.html
0
 
csehzIT consultantAuthor Commented:
.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now