Microsoft Office suite usually works very well with each other. Over time though, Outlook and Excel tend to get out of sync. One of the problems I have personally experience is attachment problems. From some strange reason when you open an Excel attachment from Outlook, Excel will open a blank page. This can be frustrating when you really need to open that attachment. Here is how to fix Excel attachments open blank from Outlook.
Below is an example of what could happen when you open an Excel 2010 attachment from Outlook 2010.
So instead of seeing your workbook or your spreadsheets there is nothing. Don’t worry too much about this because there is a really easy fix that can correct this problem for you.
How to Fix Excel Attachments Open Blank from Outlook
For this fix I will be using Excel 2010. If you have Excel 2007 you can still follow along to fix this problem. For Outlook it does not matter if you are using Outlook 2007 or 2010. As long as you are having the same problem.
Go to the Start menu and open up Excel 2007 or 2010, whichever you have. You can find Excel 2007 or 2010 under the Microsoft Office folder under the Programs folder. Or just use the Start Search and type in Excel 2007 or 2010. When Excel 2010 or 2007 opens click the File menu or Office button. If you are using Excel 2010 you will want to click on Options. If you are using Excel 2007, it will say Excel Options.
Then you will want to go to Advanced menu in the left pane. This is the same for Excel 2007 and 2010.
Scroll all the way to the bottom until you reach the General section and uncheck Ignore other applications that use Dynamic Data Exchange (DDE). This is the same in both Excel 2007 and 2010.
You are probably wondering what Dynamic Data Exchange is? Well Dynamic Data Exchange is a protocol for transferring data between applications in Windows. It will send messages between applications that share data and will use hared memory to exchange the data between the applications. So when you have this check box check Excel will ignore the data exchange from Outlook causing the blank workbook to open instead of the attachment. This is the best way to fix this Excel attachment problem. No mater what version of Excel you have, either Excel 2007 or 2010, make sure you don’t have DDE checked.
After you have finished close out Excel 2007 or Excel 2010 and try to open the attachment again. This should fix the problem but if it doesn’t or that was not checked to begin with you might have some other problems. You can post them in the comment section below or check out this website for more help.