View Single Post
 
Old 01-24-2017, 07:08 AM
HGilbert HGilbert is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2014
Posts: 6
HGilbert is on a distinguished road
Default After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it

I have one specific Excel file which generates the following very buggy behavior:

Anytime I close the file in Excel, Excel itself remains open with a grey screen (no file open). When I try to close the whole program, it asks again if I want to save the file which has already been saved and closed. If I choose "Save file", the next time I try to open that file I get the error "Run-time error 13: Type mismatch".

Fortunately, I had a backup the first time this happened and was able to restore the file. I have tested it repeatedly and it is only with this specific file and filename; if I store the same file under a different name, it closes properly and Excel does not ask to save it a second time.

I have tried restarting the computer, repairing Office, etc. Nothing helps.

The solution for me is easy; I have renamed the file and all is well. But you may want to fix the underlying bug!
Reply With Quote