{"id":4041,"date":"2022-02-25T09:34:28","date_gmt":"2022-02-25T17:34:28","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=4041"},"modified":"2022-02-25T09:34:30","modified_gmt":"2022-02-25T17:34:30","slug":"how-to-fix-microsoft-excel-is-waiting-for-another-application-to-complete-an-ole-action","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=4041","title":{"rendered":"How to Fix &#8220;Microsoft Excel is waiting for another application to complete an OLE action&#8221;"},"content":{"rendered":"\n<p><strong>1st troubleshooting<\/strong><\/p>\n\n\n\n<p>1. Open the Excel sheet and go the&nbsp;<strong>File&nbsp;<\/strong>menu. In the File menu, click on&nbsp;<strong>Options<\/strong>.<\/p>\n\n\n\n<p>2. An Excel Options dialog box will appear. Go to the&nbsp;<strong>Advanced&nbsp;<\/strong>tab and scroll down to the&nbsp;<strong>General&nbsp;<\/strong>area. Over there check&nbsp;<strong>Ignore other applications that use Dynamic Data Exchange<\/strong>&nbsp;<strong>(DDE)<\/strong>.<\/p>\n\n\n\n<p>3. Restart Excel.<\/p>\n\n\n\n<p><strong>2nd troubleshooting, if you are using Google Drive<\/strong><\/p>\n\n\n\n<p>Google Drive was my issue resulting in the &#8220;waiting for OLE action&#8221; error. I tried disabling add-ins, but that wasn&#8217;t the issue in my case. I probably shouldn&#8217;t pass the buck on this one, but it should be brought to the attention of the respective MS and Google Product development teams.<\/p>\n\n\n\n<p><strong>Error<\/strong>: &#8220;Microsoft excel waiting for another application to complete an OLE action.&#8221;<\/p>\n\n\n\n<p><strong>Cause<\/strong>:&nbsp;Certain Excel files are being stored on Google Drive or Google File Stream.<\/p>\n\n\n\n<p><strong>Solution<\/strong>: Moving the files to a local drive or desktop (i.e. the hard drive).<\/p>\n\n\n\n<p><strong>3rd troubleshooting<\/strong><\/p>\n\n\n\n<p>Have you tried to open workbooks in safe mode of Excel?<br>To run Excel in safe mode, you could hold on Ctrl key and double click Excel icon, and then choose &#8220;Yes&#8221;.<br>If this issue no longer occurs in safe mode, I also suggest you locate to&nbsp;<\/p>\n\n\n\n<p><code>C:\\Users\\&lt;User Name&gt;\\AppData\\Roaming\\Microsoft\\Excel\\XLSTART<\/code>, <\/p>\n\n\n\n<p>temporarily remove the files and subfolders in the startup item folder.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1st troubleshooting 1. Open the Excel sheet and go the&nbsp;File&nbsp;menu. In the File menu, click on&nbsp;Options. 2. An Excel Options dialog box will appear. Go to the&nbsp;Advanced&nbsp;tab and scroll down to the&nbsp;General&nbsp;area. Over there check&nbsp;Ignore other applications that use Dynamic Data Exchange&nbsp;(DDE). 3. Restart Excel. 2nd troubleshooting, if you are using Google Drive Google Drive <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=4041\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[1130,1131],"class_list":["post-4041","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-excel-is-waiting-for-another-application-to-complete-an-ole-action","tag-excel-is-waiting-for-ole"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/4041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4041"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/4041\/revisions"}],"predecessor-version":[{"id":4047,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/4041\/revisions\/4047"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}