vba “Microsoft Office Excel 正在等待另一个应用程序完成 OLE 操作”是什么意思。意思？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7193857/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What does "Microsoft Office Excel is waiting for another application to complete an OLE action." mean?
提问by Frank
I have a working RTD Excel automation add-in similar to the one described here. Intermittently, while attempting to load a sheet that includes this formula I get the following error:
我有一个工作的 RTD Excel 自动化插件，类似于这里描述的插件。间歇性地，在尝试加载包含此公式的工作表时，我收到以下错误：
Microsoft Office Excel is waiting for another application to complete an OLE action.
Microsoft Office Excel 正在等待另一个应用程序完成 OLE 操作。
I have checked and unchecked "Ignore other applications that use Dynamic Data Exchange (DDE)" per some forum discussion (which I can no longer locate). Neither works.
我已根据某些论坛讨论（我无法再找到）选中和取消选中“忽略其他使用动态数据交换 (DDE) 的应用程序”。两者都不起作用。
Google yields many hits for this error but no resolutions. There is an ancient knowledge base article herebut again no resolution.
谷歌为这个错误产生了很多点击，但没有解决方案。这里有一篇古老的知识库文章，但同样没有解决方案。
What is causing this error? Is there anything that I can do to avoid it?
是什么导致了这个错误？我能做些什么来避免它？
Thanks!
谢谢！
采纳答案by Frank
After bringing Excel up in the debugger and hitting break all it appears that my add-in is deadlocking in ConnectData. You win this time Excel.
在调试器中启动 Excel 并点击 break all 后，我的加载项在 ConnectData 中似乎死锁了。这次你赢了 Excel。
回答by PJ in FL
Try using Application.DisplayAlerts = False to stop the alerts from displaying.
尝试使用 Application.DisplayAlerts = False 停止显示警报。
回答by Malick
A bit late but it may help someone :
有点晚了，但它可能对某人有所帮助：
I just face the same issue and I find a way to know more about this error message.
我只是面临同样的问题，我找到了一种方法来了解有关此错误消息的更多信息。
After excel crashes/freeze and display this message, you can go to the Windows Event Viewer (Control Panel -> System and Maintenance -> Administrative Tools -> Double-click Event Viewer ) to get more details.
在 excel 崩溃/冻结并显示此消息后，您可以转到 Windows 事件查看器（控制面板 -> 系统和维护 -> 管理工具 -> 双击事件查看器）以获取更多详细信息。
In my case (a VSTO addin) I have got an error raised in the Net Runtime that I wasn't able to catch with the debugger. It was related to a System.AccessViolationExceptionand to a call to a native dll.
在我的情况下（一个 VSTO 插件），我在 Net Runtime 中遇到了一个错误，我无法用调试器捕捉到它。它与 aSystem.AccessViolationException和 对本机 dll 的调用有关。
So have look to the event viewer !
因此，请查看事件查看器！
