Is there a way to always keep manual spreadsheets manual?

I'm assuming the answer is no, but just wanted to ask.

So my company's ERP has an excel plugin that allows me to use custom formulas to pull in live data for calculations. works great, one of my favorite tools. problem is, it pulls in data every time you calculate a formula - the only solution is to set the workbook to calculate manually and then calculate data with a macro button.

my issue is that any time another spreadsheet gets opened, it tries to set the manual spreadsheet to calculate automatically. excel completely locks up and has to be closed through task manager. my company is having to separate linked vs non linked workbooks, but there's always someone who forgets which ones they have open and crash their excel.

I know calculation options is one of those settings that excel tries to standardize across all open workbooks. but is it possible to turn that off? maybe a macro I can make that any time it tries to go automatic, it will immediately flip back to manual?