Excel crashing while in VR. Any ideas as to why?

I have a set of workbooks that are a set of TTRPG rules and character sheets (having all of the sheets in one workbook caused excel to continuously crash). This has been working fine but for no apparent reason a couple of days ago one of the workbooks just started instantly crashing the moment you do anything with it, and even if you don't do anything it'll crash within a few minutes, this then causes all of the open workbooks to freeze. Occasionally it'll go about 10 minutes before it crashes, but that is rare. Every time it crashes however it says the workbook is saving, which seems to be true since after you end task on it all of your changes seem to have been saved even up to right before the crash, but it isn't saving. I have left it a whole hour to see if it actually will save and it doesn't.

Strangely this behaviour only seems to happen when I am in VR. Outside of VR I can't get the error to occur, at least not yet, but it is guaranteed while I am in VR. I can't think of any reason why this would be. I use the VR so I can have more and larger screens that can be easily moved around, mostly the virtual desktop app for the quest 3, but it also happens when using steamVR to give you multiple windows too. If I am not in VR though the workbook is happy as a clam, no freezes, no crashes, just works fine.

I would like a fix as the whole reason for this is to allow me to play with a VR VTT while having a custom ruleset and such floating around me ready to use.

There aren't any scripts active on the workbook that causes the freezing, so it isn't to do with scripting as far as I can tell. And at least so far all of the other workbooks work fine, but since I can't tell why this one does not (it is a character sheet and identical to other character sheets). The issue first started to happen after I created a data validation dropbox that looked at another workbook, but i have since tried deleting all of the data validation drop boxes, and highlighting the entire sheet and selecting data validation (which it says will delete all data validation rules even though it doesn't seem to have done).