Excel File Opens then immediately closes

I have a user who I e-mail daily numbers to in Excel format.  I send him two files named:
MID - MIS - Service.xls
MID - MIS - Parts.xls

He USUALLY can open the Service.xls file, but when trying to open the Parts.xls file, the file opens, displays for a brief moment, then immediately closes.  I cannot understand this since they are generally copies of the same file with different numbers.  He is running Microsoft Office 2000 (9.0.3821 SR-1) on Microsoft Windows 2003 Server.  What are your thoughts?
mshaffnerAsked:
Who is Participating?
 
redmondbCommented:
mshaffner,

If Excel is simply "disappearing" (i.e. shutting down without any message) it's very likely a corrupt spreadsheet. I'd build a new Parts.xls - ideally with nothing from the original, but copy and paste values if that's not possible.

Regards,
Brian.
0
 
Patrick MatthewsCommented:
Try disabling macros (Tools/Macros/Security) in the menu before opening.  There may be code that is forcing the closure.
0
 
Patrick MatthewsCommented:
Also, hit Alt+F11 to get to the VB Editor, and run this in the Immediate window:

Application.EnableEvents = False
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
redmondbCommented:
Hi, mshaffner,

Any possibility that there is an Auto_Open macro in Parts.xls which is closing the file?

Regards,
Brian.
0
 
redmondbCommented:
Oops, crossing posts, please ignore my previous one.
0
 
mshaffnerAuthor Commented:
The document contains no macros...
0
 
mshaffnerAuthor Commented:
However it is Shared and Protected (as is the other file).... The file is created with MS Excel 2003 (11.8341.8341).  I would assume backwards compatibility.  But you know what they say about assumptions...  
0
 
redmondbCommented:
mshaffner,

As a test, could you turn off Sharing and see if the user still has a problem? Again as a test, could you copy it (Shared and Protected) to the user's PC and see if that makes a difference?

Also, could you tell us some more about the spreadsheet - what size is it, is it just data (or does it include links, pivots, graphics, etc.)?

Thanks,
Brian.
0
 
mshaffnerAuthor Commented:
I tried saving the file from the e-mail application to the user's desktop. I also tried renaming the file.  Still has the same problem.  The spreadsheet contains only data & formulas, no links, pivots, graphics, graphs, etc.  No external file referencing either.  The file size is about 498 KB (changes as daily numbers are added).  So it's not anything real fancy.  I'll post a blank copy of the document providing the above tests are not successful.
0
 
redmondbCommented:
Thanks, mshaffner, that's great information. Just to check, did you get a chance to try an unshared version?

Oh, "immediately closes" - the spreadsheet or Excel?

Regards,
Brian.
0
 
mshaffnerAuthor Commented:
Both... Sent the file & am waiting for a response from the user.
0
 
mshaffnerAuthor Commented:
If it is a corrupt spreadsheet, why would it work on all other computers?
0
 
redmondbCommented:
mshaffner,

Yep, particularly when you've multiple versions of Excel in the mix.

Regards,
Brian.
0
 
Hendrik WieseInformation Security ManagerCommented:
Ask the user to press and hold Ctrl and then double click the file to open it, as this would open office in save mode. Hopefully the file opens.

Hope this helps!!!
0
 
mshaffnerAuthor Commented:
The user tried opening the file in Safe Mode.  No difference in behavior.  He is going to try an uninstall/re-install, but I don't think it will do any good since he can open other spreadsheets just fine.
0
 
redmondbCommented:
Thanks, mshaffner. Did you get a chance to try a rebuilt Parts.xls? (And if that doesn't help, Services.xls.)
0
 
mshaffnerAuthor Commented:
The "MID - MIS - Service.xls" file works fine.  I have not had the time yet to try and re-create the "MID - MIS - Parts.xls" file yet.  I'll let you know how it goes when I can get it done.  Meanwhile, any other suggestions would be appreciated!
0
 
redmondbCommented:
He USUALLY can open the Service.xls file - what error was he getting with Service?
0
 
mshaffnerAuthor Commented:
No error that I'm aware of.  I think that he said on occasion that file behaved the same way, opening then closing.  But he hasn't had that issue in awhile.
0
 
redmondbCommented:
Do you constantly update the two files you send or are they recreated each time?
0
 
mshaffnerAuthor Commented:
They are UPDATED each day.
0
 
redmondbCommented:
Thanks, mshaffner. I'll wait patiently until someone else sorts it out or you get a chance to do the rebuild.
0
 
mshaffnerAuthor Commented:
It's impossible to know why the original file only gave one computer problems, but building a new file has caused the problem to cease.  Thanks!
0
 
redmondbCommented:
Glad it worked, mshaffner. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.