I have excel spreadsheet that has forms, controls (drop downs, date pickers, buttons) and many name ranges and formulas.
A few days back, a user pointed out that the spreadsheet had crashed when he tried to re-open it. Later I found that the spreadsheet consistently crashed when we re-open it third time upon saving twice. Interestingly, Excel 2007 manage to open it without problem.
I’m been spending two days looking for any clue that would resolve this problem. My initial thought there must be one of those controls that caused this. But eventually found the problem was because there was a reference to external file in the Name Range (Insert > Name > Define.. )
Give this a look if you have similar problem. Hope this would save your time as I could not find this info from google.