"Cannot find the file" Problems with Excel 97.

[sobek77]

Hallo
I have problems with Excel Spreadsheets. I have windows
2000 and Excel 97. The problem is with restricted user.
Every time she tries to access something on the C:\ going
thru windows explorer she gets msg:

Cannot find the file 'C:\......xls'(or one of its
components). Make sure the path and filename are correct
and that all required libraries are available.

I happens with every Excel file when I go thru Windows
Explorer. When I open Excel and go file/open, and then I
access this spreadsheet, everything is working just fine.

Can you please help me?

 

[Gord Dibben]

sobek

First try the standard fix(es)......Tools>Options>General uncheck "ignore
other applications"

OR Start>Run "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to Excel\somewhere\excel.exe" /regserver

Gord Dibben Excel MVP

 

[Jan Karel Pieterse]

Hi Sobek77,

Cannot find the file 'C:\......xls'(or one of its
components). Make sure the path and filename are correct
and that all required libraries are available.

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
www.jkp-ads.com