Excel crashes when opening a specific (complex) .xlsb file (and all previous versions of it too)

Jaspos 

Little late to the piece but I had (and still have on occasion) this issue and use the following 14 steps to resolve it:

1. If open close all workbooks and Excel
2. Open Excel
3. Follow the path File > Options > Trust Center > Trust Centre Settings
4. In the left-hand panel of the Trust Center dialog click on Macro Settings
5. Use the Snipping Tool to take a screen shot of what the current macro settings are
6. Click the Disable VBA macros without notification radio button and unselect any other option(s)
7. Click OK twice
8. Open the binary file that is automatically closing upon trying to be opened which should now open. If still doesn't I have no idea I'm afraid 
9. Go into your code and follow the menu path Debug > Compile VBA Project
10. Fix any syntax errors and when the code compiles without issue follow the menu path File > Close and Return to Microsoft Excel
11. Save and close the binary file opened in step eight
12. Close Excel
13. Open Excel and reset the macro settings as they were from the screen shot taken in step five
14. Open the binary workbook from step eight

Hope that helps.

Regards,

Robert