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.
To work around this issue, follow these steps:
- Click Start, and then click Run.
- In the Open box, type regedit, and then click OK.
- Open the following registry key:HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
- In the right pane, click (Default).
- On the Edit menu, click Modify.
- 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)
- Click OK, and then close Registry Editor.
To change the Open action of a file type, follow these steps:
- Start the Microsoft Windows Explorer.
- On the Tools menu, click Folder Options.
- Click the File Types tab.
- Click the file type that you want (that is, Microsoft Excel Worksheet) in the Registered file types list.
- Click Advanced.
- Under Actions, click Open, and then click Edit.
- Make the changes that you want, and then click OK.
- Note: For additional file types, you may also need to review these registry locations: HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\commandHKEY_CLASSES_ROOT\Excel.SheetBinaryMacroEnabled.12\shell\Open\commandHKEY_CLASSES_ROOT\Excel.SheetMacroEnabled.12\shell\Open\commandHKEY_CLASSES_ROOT\Excel.Template.8\shell\Open\command HKEY_CLASSES_ROOT\Excel.TemplateMacroEnabled\shell\Open\commandHKEY_CLASSES_ROOT\Excel.Template\shell\Open\command