It's infuriating, isn't it. The best that I can suggest is that you open My Computer and go into the folder where you save the spreadsheets. Look for a file with an unusual looking name (might start with ~). Copy that file (for safety) and try to open it.
You might also need to change your settings to "Show hidden files" to see it.
Also look in your Temp files folder for an xls file.