Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem Opening Files
When an attempt to open an Exel file by double clicking on the file icon in
Windows Explorer the Exel window opens (without any workbook present) and the following error message is displayed: "Cannot find the file 'C:\***.XLS (or one of its components) Make sure the path (... etc)" The file can be opened by using the open command within Exel. This problem first appeared while running MS Office under Windows 98 but has persisted since upgrading to Windows 2000 Professional. I have tried Windows update and repairing the program automatically from 'ADD / REMOVE PROGRAMS' Running MS Office XP Professional Version 10.0.6626.0 Exel 2002 version 10.0.6501.0 Windows 2000 Professional Version 5.0 (Build 2194 Service Pack 4) |
#2
|
|||
|
|||
Hi Pedr,
When an attempt to open an Exel file by double clicking on the file icon in Windows Explorer the Exel window opens (without any workbook present) and the following error message is displayed: "Cannot find the file 'C:\***.XLS (or one of its components) Make sure the path (... etc)" 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 |
#3
|
|||
|
|||
May I suggest that before getting into all those procedures, you first check
this: <Tools <Options <General tab, And make sure that "Ignore Other Applications" Is *UNCHECKED* -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jan Karel Pieterse" wrote in message ... Hi Pedr, When an attempt to open an Exel file by double clicking on the file icon in Windows Explorer the Exel window opens (without any workbook present) and the following error message is displayed: "Cannot find the file 'C:\***.XLS (or one of its components) Make sure the path (... etc)" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening DBF files with Excel 2003 via Windows Explorer ? | Setting up and Configuration of Excel | |||
Running Virus Scan Slowing down opening files | Excel Discussion (Misc queries) | |||
Problem with opening an Excel - File | Excel Worksheet Functions | |||
Opening different files in excell | Excel Worksheet Functions | |||
Problem opening an XML file in Excel - getting "ns1:macrosPresent" | Excel Discussion (Misc queries) |