Solved

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

Posted on 2016-08-01
4
55 Views
Last Modified: 2016-08-01
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
Comment
Question by:csehz
  • 2
4 Comments
 
LVL 28

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 250 total points
Comment Utility
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
Comment Utility
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
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 250 total points
Comment Utility
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
 
LVL 1

Author Closing Comment

by:csehz
Comment Utility
.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

My experience with Windows 10 over a one year period and suggestions for smooth operation
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now