Excel restarting when performing a recalculation

[piannetta]

Hi, I have a spreadsheet that's been working fine until this morning. I updated data and hit F9 and about 50% of the way through, Excel just exits and restarts.

I am using Office365 so I've tried restoring to an older version from a week ago and same thing is happening.

I've rebooted my PC and same thing is happening.

Even if I open the file and do no data changes, hitting F9 still does the same thing.

I'm at a loss as to how to troubleshoot this as I've tried everything obvious to get past this.

Any ideas would be greatly appreciated.

Excel 365 (Microsoft® Excel® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20132) 64-bit)

 

[SunnyAlv]

I used to have this problem but when I changed the settings as shown I never had it again, so try it. (Optimize for compatibility)

this was my problem before I changed the option (Optimize for compatibility)