Link to home
Create AccountLog in
Avatar of csehz
csehzFlag for Hungary

asked on

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:
User generated image
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,
SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of csehz

ASKER

.