Error message when trying to open Excel

Asked By 0 points N/A Posted on -
qa-featured

Good MAE,

Recently I tried to open excel file or making new excel file and I encounter this error
 
What I have already done to correct the problem is restarting my computer, update my windows, but all of this yield nothing. 
 

 

I don't know why this problem occurs,
Please help me
 
 'c:uwappsdtoolsSYSTEMdtools32.XLL' 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.
SHARE
Best Answer by jhonkemp
Best Answer
Best Answer
Answered By 0 points N/A #122337

Error message when trying to open Excel

qa-featured

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.

Answered By 0 points N/A #122339

Error message when trying to open Excel

qa-featured

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:

  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_ROOTExcel.Sheet.8shellOpencomma

       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 FILESMICROSOFT OFFICEOFFICEEXCEL.EXE" /e (including the quotation marks)

       7. Click OK, and then close Registry Editor.

Answered By 0 points N/A #122338

Error message when trying to open Excel

qa-featured

Hi dear,

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.

  • Go to MS Excel
  • Go to tool menu and select Add-ins
  • In the Add-ins window find Dtools32 (See the image below)
  • Check the Dtools32 box and select OK

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.

Related Questions