The Old New Thing : When I double-click an Excel spreadsheet, Excel opens but the document doesn’t:
So exactly why would one check the box that tells Excel “Ignore other applications that use Dynamic Data Exchange”, that ends up screwing up Excel’s open up the file and Outlook opening up an Excel file?
Because when your Word based document that had an Excel linked file kept freaking out with an error message saying “a document with the name is already open” that’s the exact instructions that I googled on a post somewhere…
Two days later when the guy couldn’t open up and preview an Excel attachment in Outlook and I googled on that error I realized that the fix for one problem created a much larger one.
We now live with the Word/Excel link document warning.
The amazing thing about this issue is that it googles all the way back to like Excel 97…and we’re running Excel 2007.
Oh yeah there was some other registry hack thingy I tried as well.. but bottom line if you wondered why anyone would do that “ignore DDE” it’s because site tells you that it’s what you need to fix another issue. Trust me, it doesn’t. It makes another issue.