Opening an excel file returns a blank worksheet

J

JVenner

Have a user who is running excel 2000 when they try to open a excel worksheet
they receive a blank worksheet - the only way from them to open up a
worksheet is to go to the open and select the file. 25 users at this site
only one having this problem. Anybody have experience with this ?
 
C

CLR

Check Windows Explorer > Tools > FolderOptions > FileTypesTab > and be sure
the XLS extention is associated with Excel.

hth
Vaya con Dios,
Chuck, CABGx3
 
D

Dave Peterson

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

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.

Maybe one of these will work for you.
 
J

JVenner

File Associations were there - deleted file association and then re-linked
associations - next thing I guess to try is removing excel from the machine
and then reinstalling.
 
G

Gord Dibben

Did you try either of Dave's suggestions?

I would do that before re-installing.

One more thing to try............

Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE9\EXCEL.EXE" /e (delete the <sp>/e if
you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)


Gord Dibben MS Excel MVP
 
Top