Excel lags when switching between automatic & Manual calculations

[kgkev]

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?

 

[offthelip]

Have you checked your personal.xlsb file to see whether that is causing the problem, or any other workbook that starts up automatically.

 

[kgkev]

yes, personal was deleted and recreated, no other workbooks open at the same time.