Excel files won't open from desktop

[dhattala]

I cannot open an Excel file from it's location in My
Documents or on the desktop. Excel will launch but the
data does not appear. However, I can open Excel first and
open the document from within Excel. How can I
reestablish the link to open direct from the file
itself? I'm using Excel 2002.

 

[Jan Karel Pieterse]

Hi Dhattala,

I cannot open an Excel file from it's location in My
Documents or on the desktop. Excel will launch but the
data does not appear. However, I can open Excel first and
open the document from within Excel. How can I
reestablish the link to open direct from the file
itself? I'm using Excel 2002.

Start, Run,
"C:\Program Files\Microsoft Office\Office\Excel.exe" /regserver

Quotes mandatory, Note you may have to change the path.

This is what MS has to say startup switches:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q211481


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[debbie]

We tried this as a solution for someone who was having
problems opening Excel files from e-mail, shortcuts, etc.
This was last week, and it worked, but the problem has
since returned. Should this have fixed it permanently?
Any other suggestions for permanently fixing this issue?

Thanks! Debbie

-----Original Message-----
Hi Dhattala,



Start, Run,
"C:\Program Files\Microsoft

Office\Office\Excel.exe" /regserver

 

[Jan Karel Pieterse]

Hi Debbie,

We tried this as a solution for someone who was having
problems opening Excel files from e-mail, shortcuts, etc.
This was last week, and it worked, but the problem has
since returned. Should this have fixed it permanently?

AFAIK, yes.

Any other suggestions for permanently fixing this issue?

You might try this:

1. Open Windows Explorer.
2. Choose from its menu: View, Options. (or View / Folder Options in
Windows 98)
3. Select the File Types tab
4. Scroll to Microsoft Excel Worksheet
5. Click Edit
6. Select the OPEN entry (it should be highlighted (bolded)
7. Click Edit and check that the fields are set as follows:
a) Application used: should be EXCEL.EXE, loaded from the correct
directory
b) Use DDE should be checked
c) The DDE message should be (exactly): [Open("%1")]
d) Application should be: excel
e) DDE Application not running should be empty
f) Topic should be: system
8. Click OK
9. Click Close
10. If you wish to double-click other Excel file types, e.g. template
(xlt) or workspace (xlw), select the appropriate type in the File Types
tab and repeat from step (5)

But the regserver trick should do the same.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com