A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
I started having this problem late last this week after the infrastructure team pushed Office updates to our laptops.
The current version is: Microsoft® Excel® for Microsoft 365 MSO (Version 2204 Build 16.0.15128.20210) 64-bit
Excel and/or the file kept crashing at the point in my script where a pivot table tried to refresh with source data that is a table populated with an OData connection. I tried a whole pile of things to get the file working again. Nothing seemed to work. Changing my display setting from 125 to 150 solved the problem. That is bizarre. Thank you Snoek for figuring this out. I don't think I ever would have thought to change that setting.
One additional piece of info, in case someone at MSFT reads this. The file I'm using is synced from a Teams site, which is effective a Sharepoint document store.