[Fixed!] Excel Attachments Not Opening from Outlook (6 Quick Solutions)

The sample dataset contains the dataset of 10 fruit items and their amount. The name of the fruit items is in column B, their quantity is in column C, and their delivery destination is in columns D and E. Our dataset is in the range of cells B5:E14. We attached the file called Excel Attachments Not Opening from Outlook.xlsx in our Outlook mailbox to show you how to fix the problem.

Solution 1 – Disable All Excel Add-ins to Open Attachments

Steps:

Select File > Options.

In the Excel Options dialog box, select the Add-ins option.
In the Manage option, select the drop-down arrow and change the option Excel Add-ins to COM Add-ins.
Click Go.

In the COM Add-ins dialog box, uncheck all the Add-ins available.
Click OK.

Restart Microsoft Outlook and double-click on the Excel attachment.

The attachment file will open.

Solution 2 – Change Excel Advanced Options to Open from Outlook

Steps:

Select File > Options.

In the Excel Options dialog box, select Advanced.
Select General.
Uncheck Ignore other applications that use Dynamic Data Exchange (DDE).
Click OK.

Close the Excel file.
Launch Microsoft Outlook and double-click on the Excel attachment.

The attachment file will open.

Solution 3 – Adjust Excel Trust Center Settings

Steps:

Select File > Options.

In the Excel Options dialog box, select Trust Center.
Select Trust Center Settings.

In the Trust Center dialog box, choose Protected View.
Keep the Protected View option as shown in the image. Check the 2nd option named Enabled Protected View for files located in potentially unsafe locations and uncheck the other two options.
Click OK.

Click OK and exit from Microsoft Excel.
Open Microsoft Outlook and double-click on the Excel file attached in the mailbox.

The Excel file will open.

Solution 4 – Modify Windows Registry Key Settings

Steps:

Press ‘Window+R’ to launch the Run Prompt.
Enter ‘regedit’ and click OK.

A dialog box Registry Editor will launch.
Follow the following path to get the folder:

HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ Office\ ClickToRun\ REGISTRY\ MACHINE\ Software\ Microsoft\ Windows\ CurrentVersion\ Preview Handlers

Modify the newly created string.
Double-click on the string name and a dialog box named Edit String will open.
Enter the Value name as {00020827-0000-0000-C000-000000000046} and the Value data as Microsoft Excel previewer.
Click OK.