file opens and disappears

[Ken]

I have an Excel file that opens but does not show. It is not in the list of
open Excel files, but if I try to open it again the system indicates that it
is already open. I can see the file listed in Visual Basic editor (F11).
The file does not contain macros but it does have several levels of
subtotals. I can open it in Word but it us not useable in that application.
It is a large file and not easily duplicated.

 

[max]

have you found an answer to your question? If so please tell me what you
have found

 

[Ken]

I was able to solve the problem although I don't know the orininal cause.
Microsoft is not going to like my solution. I was able to open and display
the file using Open Office Calc. I then resaved the file with the 'xls'
extension and can now open and see it using Excel.

 

[Kris]

I have an Excel file that opens but does not show. It is not in the list of
open Excel files, but if I try to open it again the system indicates that it
is already open. I can see the file listed in Visual Basic editor (F11).
The file does not contain macros but it does have several levels of
subtotals. I can open it in Word but it us not useable in that application.
It is a large file and not easily duplicated.

It can be many reasons, but try this:
Open your excel file goto VBE (F11) type Ctrl+G to open immediate
windows and execute
ThisWorkbook.IsAddin = false

 

[Axel]

I have an Excel file that opens but does not show. It is not in the list of
open Excel files, but if I try to open it again the system indicates that it
is already open. I can see the file listed in Visual Basic editor (F11).
The file does not contain macros but it does have several levels of
subtotals. I can open it in Word but it us not useable in that application.
It is a large file and not easily duplicate

I had the same problem. I had fastfingered and hid my file by mistake.
This means that opens but you can't see it. All I did was to go to
Windows -> Unhide where I could see the file and then chose to unhide
it.