Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2017, 07:08 AM
HGilbert HGilbert is offline After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it Windows 7 64bit After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it Office 2010 64bit
Novice
After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it
 
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
  #2  
Old 01-24-2017, 08:37 AM
HGilbert HGilbert is offline After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it Windows 7 64bit After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it Office 2010 64bit
Novice
After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it
 
Join Date: Jun 2014
Posts: 6
HGilbert is on a distinguished road
Default

Perhaps related...I sometimes cannot delete documents because Word thinks they are open -- even if I have closed Word!! Only after I close a (mysteriously still open) Word process through the Task Manager can I delete the document.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save Excel file with specific cell value by using VBA code IAMCHEESE Excel Programming 1 11-02-2016 07:11 PM
After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it Importing Data from seperate closed excel file KingoftheKassel Excel Programming 1 06-10-2016 08:34 AM
EXCEL tries to close a file userman Excel 2 05-31-2012 03:15 AM
After a specific file is closed, Excel asks again if I want to close the same file -- and ruins it Word 2003 > close > it asks to save a global template tom8750 Word 10 05-23-2011 03:29 AM
OFFICE(Word,Excel..)-crash/close when DIALOG BOX launched of insert image,open file buggingme Office 1 05-30-2010 12:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft