I have had countless issues with my excel files working fine and then at some random reason excel crashes whenever I try to save or mostly even just open the file. The reason always seems to be connected to references. I used to have ticked:
"Visual Basic for Applications"
"Microsoft Excel 15.0 Object Library"
"Microsoft Office 15.0 Object Library"
"OLE Automation"
After having a lot of files randomly starting to crash on open, I found out that unticking
"Microsoft Office 15.0 Object Library"
"OLE Automation"
in the VBA references usually fixed that issue.
However, now I am coming across problems where I cannot save a file and have to activate "Microsoft Office 15.0 Object Library" again. This is quite confusing and frustrating.
Does anybody understand what is going on and is there a fix for this? My workbooks are mostly heavily using PowerQuery with some Power Pivot and VBA-code.