Excel lags when switching between automatic & Manual calculations

kgkev

Well-known Member
Joined
Jun 24, 2008
Messages
1,245
wonder if anyone has a fix for this problem. it is not related to actual calculation time as the effect occurs even with a new blank sheet.

I will do my best to explain and hope someone has come across the problem as well.

With a new and blank sheet changing from Automatic to manual causes excel to freeze (Not responding) for 10-15 seconds. After the freeze you can swap between calc modes without delay.
however selecting a random couple of cells and then changing calculation mode causes excel to freeze again.

A few note and things I have tried
Using Office 365 first noticed the problem in 2016.
Forced through an upgrade to 2019 and the problem still occurred.
I uninstalled and ran the MS Office cleanup tool then reinstalled - same problem
All Add-ins disabled - same problem
Excel Safe mode - - same problem

Run excel as a different user on the same PC - No problem.
Delete and recreate the user profile - Problem fixed!

I thought that was the end of it....however another PC is having the exact same problem and I want to avoid recreating the user profile if possible.
Does anyone have a suggestion what we can try?
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

offthelip

Well-known Member
Joined
Dec 23, 2017
Messages
1,636
Office Version
  1. 2010
Platform
  1. Windows
Have you checked your personal.xlsb file to see whether that is causing the problem, or any other workbook that starts up automatically.
 

kgkev

Well-known Member
Joined
Jun 24, 2008
Messages
1,245
yes, personal was deleted and recreated, no other workbooks open at the same time.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,168
Messages
5,594,632
Members
413,919
Latest member
ZaxAlchemist

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top