When i have automatic calculation on, excel freezes. When i push the escape key i get focus back to excel but then it nearly immediatley loses focus again. I have to keep hitting excel to navigate anywhere with excel. By turning calculations to manual it no longer freezes. Is there a way to identify whats causing this freeze, I went through and deleted nearly all events? Why would auto calculate freeze excel if no changes are being made to a formula? What exactly is escape doing to give me focus back temporarily? Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
automatic calculation causes freeze
- Thread starter brenton
- Start date
Excel Facts
When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
prince141987
Board Regular
- Joined
- Jul 31, 2011
- Messages
- 135
Do you have formulas on you sheet ? If there are formulas on the sheet they get calculated always and it takes lot of calculation time.
Upvote
0
Similar threads
- Replies
- 0
- Views
- 169
- Replies
- 3
- Views
- 582
- Question
- Replies
- 0
- Views
- 143
- Replies
- 1
- Views
- 567
- Replies
- 0
- Views
- 377
