Article ID: 207574 - View products that this article applies to.
This article was previously published under Q207574
Expand all | Collapse all

Symptoms

When you double-click a Microsoft Excel file type (.xls), Excel starts as expected, but then you may receive an error message that is similar to the following:
C:\filename.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.
When you click OK on the error message, the message reappears. After you repeatedly click OK, the file opens.

Cause

This behavior can occur if the Open action entry for this file type ends in %1.

If the Open action of the file type is edited and the line is restored before you press OK, a %1 is added to the registry key.

If you intentionally add a %1 to the Open action entry for this file type, a %1 is added to the registry key. If you subsequently delete the %1 from the Open action entry, the registry key remains unchanged and must be manually edited.

Additionally, this issue can occur when you manually change the file association of .xls files, or in some circumstances, when you are running multiple versions of Excel on the same computer.

Resolution

To resolve this issue, install the latest cumulative updates for Office Excel. You can find the latest cumulative updates by following the following link:
953878 Cumulative updates are available from the Microsoft Office team to deliver hotfixes for reported problems

Workaround

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows

To work around this issue, follow these steps:
  1. Click Start, and then click Run.
  2. In the Open box, type regedit, and then click OK.
  3. Open the following registry key:
    HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
  4. In the right pane, click (Default).
  5. On the Edit menu, click Modify.
  6. Remove the %1 from the end of the Value data string so that the data string reads as follows:
    "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (including the quotation marks)
  7. Click OK, and then close Registry Editor.

More information

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
To change the Open action of a file type, follow these steps:
  1. Start the Microsoft Windows Explorer.
  2. On the Tools menu, click Folder Options.
  3. Click the File Types tab.
  4. Click the file type that you want (that is, Microsoft Excel Worksheet) in the Registered file types list.
  5. Click Advanced.
  6. Under Actions, click Open, and then click Edit.
  7. Make the changes that you want, and then click OK.
  8. Note: For additional file types, you may also need to review these registry locations:
    HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command
    HKEY_CLASSES_ROOT\Excel.SheetBinaryMacroEnabled.12\shell\Open\command
    HKEY_CLASSES_ROOT\Excel.SheetMacroEnabled.12\shell\Open\command
    HKEY_CLASSES_ROOT\Excel.Template.8\shell\Open\command
    HKEY_CLASSES_ROOT\Excel.TemplateMacroEnabled\shell\Open\command
    HKEY_CLASSES_ROOT\Excel.Template\shell\Open\command

Properties

Article ID: 207574 - Last Review: August 4, 2012 - Revision: 7.0
Applies to
  • Microsoft Office Excel 2007
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2010
Keywords: 
kbinfo kbregistry kberrmsg kbopenfile kbprb KB207574

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com