Excel 2007 can't locate files

[Lars Edlo]

Quite suddenly, one year after installation, my Excel 2007 fails to locate my
excel files!
The message goes: "The file C:\user\myname etc etc... cannot be found.
Please check that you have given the right name and try again."
This happens wether i try to open directly from My Documents or from a
shortcut.
I have however discovered that I am able to open excel files who are still
on the history list of recent files under the Office button. But NOT from the
list "recent files" under the Start button...
This error only happens with Excel, not the other Office programs. I am
running on Vista Business.
I am contemplating reinstalling Excel altogether, but I don't want to
reinstall the whole Office package from the CD. Is this possible.
Thanks for any help!

 

[Jan Karel Pieterse]

Hi Lars,

The message goes: "The file C:\user\myname etc etc... cannot be found.
Please check that you have given the right name and try again."

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