Cannot open Excel documents

[hamaefo]

Using Excel 2007 (but with xls format) with Vista Professional. When I double
click (or right click on open) on Excel documents in Explorer, I get a
message that the document cannot be found. Appreciate help to solve this
problem.

 

[Jan Karel Pieterse]

Hi Hamaefo,

Using Excel 2007 (but with xls format) with Vista Professional. When I double
click (or right click on open) on Excel documents in Explorer, I get a
message that the document cannot be found. Appreciate help to solve this
problem.

How to reinstate Excel's ability to open files with spaces
in their name/path by double clicking:

1. Have Excel correct it

1. Choose start (Start button), Run, type:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver
2. Click OK

2. Do it yourself

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)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[hamaefo]

Hi Jan,
Thanks for response. Having tried to use the methods you described, I must
admit that I gave up. To me the descriptions seem to be for XP version (or
older), but not for Vista. Appreciate if you could provide one that works
with Vista.

Best regards,

Hans-Martin

Hi Hamaefo,

Using Excel 2007 (but with xls format) with Vista Professional. When I double
click (or right click on open) on Excel documents in Explorer, I get a
message that the document cannot be found. Appreciate help to solve this
problem.

How to reinstate Excel's ability to open files with spaces
in their name/path by double clicking:

1. Have Excel correct it

1. Choose start (Start button), Run, type:
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver
2. Click OK

2. Do it yourself

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)

For the XLVIEWER:

- Use DDE turned OFF
- Command line: "c:\program files\xlview\xlview.exe" "%1"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Jan Karel Pieterse]

Hi Hamaefo,

Thanks for response. Having tried to use the methods you described, I must
admit that I gave up. To me the descriptions seem to be for XP version (or
older), but not for Vista. Appreciate if you could provide one that works
with Vista.

The start, run should work with vista, but you may have to run as
administrator. I'm sorry to say I don't have Vista, so I can't work out the
details for you.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[hamaefo]

Hi Jan,

Thanks for reply. There is no "run" in Vista as I can recall from XP and
previous platforms, so I stumble right in the start. Any other ways to start?

Hans-Martin

 

[Jan Karel Pieterse]

Hi Hamaefo,

I'll get back to you about this.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Jan Karel Pieterse]

Hi Hamaefo,

Thanks for reply. There is no "run" in Vista as I can recall from XP and
previous platforms, so I stumble right in the start. Any other ways to start?

You can use the new Start, Search Menu in Windows Vista as a run box. You can
run any command you type in
as an administrator by holding down CTRL + Shift and then pressing Enter.

So enter this in the search box:

"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /Regserver

and confirm using control+shift+enter.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com