Excel opened a file but did not show it's contents

E

el

Hi all,
One of my colleagues tried to open an Excel file. Excel opened the file (no
error was shown up) but it didn't show the contents of the file. If you
have 2 files originally opened in Excel, Excel only shown those 2 file
windows in it. The newly opened one disappeared. Have anyone of you came
across this before? Any ideas to fix the problem are welcome. TIA

el
 
D

Dave Peterson

Does this mean you looked under the Window option on the menubar and didn't see
all the workbooks that you think you opened?

If you could see the name, maybe it's just off the visible screen:
Window|Arrange|tiled (and resize manually)

or maybe you hid it
window|unhide

How did you try to open the file after you saved to your HD? Doubleclicking or
File|open.

If file|Open works, but doubleclicking doesn't, you may want to try one of
these:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

An alternative might be to do:
Try Tools|Options|General|Ignore other applications (uncheck it)
 
D

Debra Dalgleish

Choose Window>Unhide, and see if the file is listed there.

If it is, select the file name, and click OK
 
E

el

Dump fool myself, I should be able to spot it. The workbook was hidden
accidentally. Thanks for all helping hand. You guys are "SUPER". Thanks
again.

Does this mean you looked under the Window option on the menubar and didn't
see
all the workbooks that you think you opened?

If you could see the name, maybe it's just off the visible screen:
Window|Arrange|tiled (and resize manually)

or maybe you hid it
window|unhide

How did you try to open the file after you saved to your HD? Doubleclicking
or
File|open.

If file|Open works, but doubleclicking doesn't, you may want to try one of
these:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

An alternative might be to do:
Try Tools|Options|General|Ignore other applications (uncheck it)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top