Which repeated all the time for several minutes until I forced Excel to shut down. “Microsoft Excel is waiting for another application to complete an OLE action” This discrepancy caused the following error: In my case for example as the COM Add-in, I had the Foxit reader whereas I use Acrobat Reader. It happens often when the Excel file with the embedded content is migrated between various computers. Usually, the problem is caused by the add-in not being compatible with the application being used for the given purpose. When we have the list of COM Add-ins opened, all the items included there must be switched off. COM Add-ins are typically used for automating Excel in the case of clicking a CommandBar button, a form, or a dialog box. You will see the list of all COM Add-ins. If not, there is another step to do: File -> Options -> Add-Ins, and in the Manage: instead of Excel Add-ins we should select COM Add-ins and hit “GO”. This approach potentially should fix the problem. You need to go to File -> Options -> Advanced -> General and switch on the “Ignore other applications that use Dynamic Data Exchange (DDE)”. How about in the situation, when the user is unable to open the embedded file in Excel? There are at least three solutions for it and in this article, I will show you one of them.īefore I do it, I just want to show potentially the easiest option to fix it, which sometimes works. The technology, which allows Microsoft Excel to embed some external files is Object Linking and Embedding (OLE), which is a pivot thing for the interaction of Microsoft Excel with other applications like Acrobat Reader.
When users exaggerate and embed something massive into the Excel workbook it might happen, that the embedded file won’t open properly if it opens at all. These inserted files can be small or large. This insertion means, that the external file becomes an i ntegral part of our Excel document, which becomes a sack of many files attached to various parts of the workbook. Microsoft Excel is a powerful tool, which allows a user even to embed some external objects (files).
0 kommentar(er)
