VBA recalculation settings acting odd

[roscoe]

Hoping I'm not the only one...but I have code that turns off auto-recalc prior to running and turns it back on when it's complete (significant time savings).

Problem is, it doesn't always work. Sometimes I can still see "calculating" messages flashing on the screen, and other times when it ends it stays in manual calc mode. It appears to only work as intended when I don't have other macro-workbooks open (I have a timecard project that I tend to leave open).

Is there a way to isolate the workbooks such that these things don't happen?

 

[diddi]

.calculation is application level. you could try running this workbook in a new instance of excel.

 

[roscoe]

How? In older versions of office that was easy, but not sure how to do that now...

 

[diddi]

right click and choose excel

 

[roscoe]

Then maybe it's the way they set up our network, but for me that only opens a fresh window, not a new instance of Excel.

 

[diddi]

hmm. sorry, thats all i do. i am running excel 2010 on Win10 x64 21H1