Error message when trying to open Excel
Two solutions to handle this problem:
1. Check the character length of file. If it's more than 218 characters, then you have crossed the limit.
2. In main menu go to tools then click on folder option, then click on file type and then highlight Microsoft Excel Worksheet and then click on edit button: change Microsoft officeofficeexcel.exe to Microsoft officeofficeexcel.exe%1
Make sure that use DDE is checked.
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 problem can happen when you manually change the file association of .xls files, or in some situations, when you are running multiple versions of Excel on the same computer.
To resolve this issue, install the latest cumulative updates for Office Excel.
Cumulative updates are available from the Microsoft Office team to deliver hotfixes for reported problems
You can also change the registry, but serious problem might occur if you INCORRECTLY modified the registry. To ensure that you did the right thing, please follow the steps below:
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:
7. Click OK, and then close Registry Editor.
Most of the time, this error comes when you use lab computers or log in with different users.
Follow the instruction below to remove the error message.
And also this may occur when system registry got corrupted or missing. There you can go to the run box and give “regedit”. Thereby selecting default option you can reset it.
When a single computer is shared a by different users you cannot be assured that the system files are maintained properly.