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



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 10:06 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