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:
![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,
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:
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,
Microsoft ExcelMicrosoft Office
Last Comment
csehz
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
.
And you may use F9 ( to calculate all the worksheets in all the open workbooks) or Shift+F9 to calculate the Activesheet only.