Open from WinExplorer Fails to Open XLS File Properly

  • Thread starter Thread starter Andre Uys
  • Start date Start date
A

Andre Uys

I have Office XP.

With Excel not currently running, I double-click to open an Excel file from
XP Explorer.

Excel launches, but the grid (rows, columns / cells) do not show the content
of the file. The screen that had focus before I double clicked seems to fill
the grid area. I can see Excel's toolbars at the top and bottom of the
screen and the application shows on the task bar.

If I click View Full Screen, the grid shows. If I undo Full Screen, the grid
is still visible.

Some variation for clarification:
-If Excel currently running, the file loads OK
-If I open the file using File Open or the related Icon, the file shows as
expected
-Minimizing and restoring Excel does not refresh the screen and show the
grid as would be expected
-Does not matter whether the file was created on my PC using my Excel or
Excel from another PC

I used to have Office 97 on this machine and the same problem them. I did a
complete un-install before I installed Office XP.

Thanks for any help
Andre
 
Maybe it's just off the visible screen:
Window|Arrange|tiled (and resize manually)
 
Thanks Dave,
I am not a total idiot :-)

This is not the issues here. Excel does not refresh to display the grid.

Thanks anyway
Andre
 
You're saying that another application shows through the excel window?

If yes, I've seen a couple of posts that say this "feature" is new with xl2002.
(I've never seen it.)

But if I recall correctly, the solution was to reboot the pc. (Not a very
elegant solution.)

(And I didn't mean to imply anything (total or even semi <vbg>) by my first
guess!)
 
Thanks Dave,
Thanks again for you input but I doubt that this is a
feature. Maybe shows trough is not a good explanation. Let me try explain
this again.

The Excel window draws on the screen, the top holds the Tool and Menu Bars
and the bottom the draw toolbar. Excel is thus on the screen but between
these two panes there is nothing. It is as if Excel draws these two panes,
but did not draw the screen that should have been between the two panes, AKA
the Rows and Columns.

I am familiar with the refresh and draw function in VB for instance. Thus I
am concluding that when I switch to full screen mode, it forces the code to
redraw the entire Excel screen and only then do I see what I should.

Reboots do not seem to have any effect on the system and the problem

Thanks Again

Andre
PS No offence was taken :-) but sometimes I guess people do ask questions of
which the solutions are obvious, I doubt this is the case with this one.
 
Do you see a grey background--like when you leave excel open, but close all the
workbooks?

Do you get any error message at all?

If the workbook isn't opening, you may want to try 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)


Andre said:
Thanks Dave,
Thanks again for you input but I doubt that this is a
feature. Maybe shows trough is not a good explanation. Let me try explain
this again.

The Excel window draws on the screen, the top holds the Tool and Menu Bars
and the bottom the draw toolbar. Excel is thus on the screen but between
these two panes there is nothing. It is as if Excel draws these two panes,
but did not draw the screen that should have been between the two panes, AKA
the Rows and Columns.

I am familiar with the refresh and draw function in VB for instance. Thus I
am concluding that when I switch to full screen mode, it forces the code to
redraw the entire Excel screen and only then do I see what I should.

Reboots do not seem to have any effect on the system and the problem

Thanks Again

Andre
PS No offence was taken :-) but sometimes I guess people do ask questions of
which the solutions are obvious, I doubt this is the case with this one.
Click to expand...
 
Looks like to problem corrected itself !!!???

Thanks for your help, and should the problem rear it's head again I will try
some of your suggestions

Andre
 
My favorite kind of problem--disappeared by itself!

Andre said:
Looks like to problem corrected itself !!!???

Thanks for your help, and should the problem rear it's head again I will try
some of your suggestions

Andre
Click to expand...
 
Back
Top