file opens and disappears

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Ken said:
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.
Click to expand...

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
 
Ken said:
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
Click to expand...

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.
 
Back
Top