Can you do automatic/manual formula calculation BY workbook?

[mischifous]

I have a very large workbook that i need to have open all the time, but I need it to be in manual or else excel/my computer is too slow. During the day I open other workbooks that are normal-sized, and it's annoying that they can never be automatic. Is there a way to have one workbook that is open running manual calculation, and the rest, or others at automatic?


thanks!

 

[Joe4]

Try opening them in different instances of Excel.
See: https://excelgorilla.com/excel/general/open-multiple-instances-excel/

 

[mischifous]

Thanks Joe4.
What about by worksheet?

 

[Joe4]

What about by worksheet?

You mean different worksheet within the same workbook having different calculation modes?
I am pretty sure that is not possible, since all open files in the same Excel session use the same calculation mode.
See: https://support.microsoft.com/en-us/help/214395/how-excel-determines-the-current-mode-of-calculation