Outlook is a platform of Microsoft Office for sending emails to others. Sometimes we attached some other types of files like Word, Excel, Pdf, etc with our mail and sent them to others. To ensure the attachment of the correct file with the email, sometimes we need to open it from Outlook. However, sometimes due to some unavoidable issues, we cannot open the file from Outlook. In this article, we will demonstrate to you 6 possible solutions to fix Excel attachments not opening from Outlook.
Excel Attachments Not Opening from Outlook: 6 Possible Solutions
For demonstrating the approaches, we are considering a delivery 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. So, we can say that 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 and show you how to fix the problem, Excel attachments not opening from Outlook.
Solution 1: Disable All Excel Add-ins to Open Attachments
In this method, we will remove all the Add-in features checked in Excel, to open the Excel file from Outlook. The steps of this process are given below:
📌 Steps:
- First of all, select File > Options.
- A dialog box titled Excel Options will appear.
- Now, select the Add-ins option.
- Then, in the Manage option, select the drop-down arrow and change the option Excel Add-ins to COM Add-ins.
- Next, click the Go button.
- Another dialog box called COM Add-ins will appear.
- After that, uncheck all the Add-ins available in that box.
- Click the OK button to close the window.
- Now, restart Microsoft Outlook and double-click on the Excel attachment.
- You will see the attachment file open on your device.
Finally, we can say that our method worked perfectly and we are able to fix Excel attachments not opening from Outlook.
Read More: Excel Files Not Opening from File Explorer
Solution 2: Change Excel Advanced Options to Open from Outlook
In this process, we will change the Excel Advanced features to open the Excel attachment file. We will use the same Excel file to open from Outlook. The steps of this method are given as follows:
📌 Steps:
- At first, select File > Options.
- A dialog box called Excel Options will appear.
- Now, select the Advanced option.
- After that, scroll down with the help of your mouse to find the General option.
- In the General tab, uncheck Ignore other applications that use Dynamic Data Exchange (DDE) option.
- Finally, click OK to close the Excel Options dialog box.
- Then, click on the Close button on the right-corner of the Excel window to close the file.
- Next, launch Microsoft Outlook on your device and double-click on the Excel attachment.
- You will get the attachment file opened on your device.
Thus, we can say that our method worked effectively and we can fix Excel attachments not opening from Outlook.
Read More: [Fixed!] Excel File Not Opening on Double Click
Solution 3: Adjust Excel Trust Center Settings
In the following process, the Trust Center Settings of Excel will help us to open the Excel attachment file from Microsoft Outlook. The procedure is explained below step by step:
📌 Steps:
- At the beginning of this process, select File > Options.
- A dialog box entitled Excel Options will appear.
- After that, in this box, select the Trust Center option.
- Then, select the Trust Center Settings option.
- Another dialog box called Trust Center will appear.
- In this dialog box, choose the Protected View option.
- Now, keep the Protected View option as shown in the image. Make sure that you check the 2nd option which is called Enabled Protected View for files located in potentially unsafe locations and uncheck the other two options.
- At last, click OK to close the Trust Center dialog box.
- Finally, click the OK button and exit from Microsoft Excel.
- Open Microsoft Outlook and double-click on the Excel file attached in the mailbox.
- You will see that the Excel file will open on your computer.
In the end, we can say that our working method worked effectively and we are able to open Excel attachments from Outlook.
Read More: [Fixed!] Unable to Open Excel Files Directly by Clicking on the File Icon
Solution 4: Modify Windows Registry Key Settings
The modification of the Windows Registry key is another way to fix the file opening issue. In this process, we will show how to modify the Windows Registry key so that the Excel attachment file can open from Microsoft Outlook.
📌 Steps:
- Firstly, press ‘Window+R’ to launch the Run Prompt.
- Write down ‘regedit’ into the empty box of that prompt and click OK.
- A dialog box entitled Registry Editor will launch.
- Now, follow the following path to reach the final desired folder:
- After that, modify the newly created string.
- Double-click on the string name and as a result, a small dialog box titled Edit String will appear.
- Now, write down the Value name as {00020827-0000-0000-C000-000000000046} and the Value data as Microsoft Excel previewer.
- Click OK to close the Edit String dialog box.
- Finally, click the close button to close the dialog window.
- After that, open Outlook on your computer and double-click on the Excel file.
- You will see that the Excel file will open on your computer.
So, we can say that our working method worked successfully and we are able to open Excel attachments from Outlook.
Solution 5: Change Outlook Options to Open Excel Attachment
The Excel attachment file opening problem can resolve by modifying the Options of the Outlook application. The approach is described below:
📌 Steps:
- To start this process, first launch Microsoft Outlook on your device.
- Then, select File > Options.
- A dialog box titled Outlook Options will appear.
- Now, select the Trust Center > Trust Center Settings option.
- After that, select the Attachment Handling > Attachment and Document Previewers option.
- Another dialog box called File Previewing Options will appear.
- Then, scroll down with your mouse and uncheck the Microsoft Excel Previewer option.
- Click OK to close the dialog box.
- Again, click OK to close the Trust Center dialog box.
- Similarly, click OK to close Outlook Options.
- Now, if you double-click on the Excel attachment file in outlook, it will open without any problem.
Finally, we can say that our working approach worked successfully and we are able to open Excel attachments from Outlook.
Solution 6: Repair Office 365 Application
In this case, we have to repair the complete Office 365 applications from the Windows Settings. This repairing process is almost similar to the re-installation of Office 365. The whole procedure of this process is given below.
📌 Steps:
- At first, select the Search button on your device and write down Control Panel in that box.
- Click Open to launch the Control Panel.
- The Control Panel dialog box will appear.
- Then, select the Uninstall a Program locates below the Programs feature.
- The Programs and Features window will open in front of you.
- Now, scroll down with your mouse to find Microsoft 365 -en-us.
- After that, right-click on your mouse and select the Change option.
- A new window from Microsoft will open with two types of Repair options.
- Then, check the Quick Repair option and select the Repair button.
- It will take a long period to repair the complete Microsoft Office application.
- Now, launch Microsoft Outlook and double-click on the Excel attachment.
- Finally, you will see the attachment file open on your device.
Lastly, we can say that our method worked successfully and we are able to fix Excel attachments not opening from Outlook.
Read More: [Fixed!] Why Is My Excel Not Opening Files?
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
Conclusion
That’s the end of this article. I hope that this article will be helpful for you and you will be able to fix the issue of Excel attachments not opening from outlook. Please share any further queries or recommendations with us in the comments section below.
Related Articles
- Unable to Open Two Excel Files at the Same Time
- Excel Files Not Opening in Separate Windows
- [Fixed!] Excel File Opens Blank Grey Screen
- [Fixed!] Excel File Open but Not Visible
<< Go Back to Excel Not Opening Files | Excel Files |Â Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
