COM timeout Excel

Question

Microsoft 465 Excel version 2403.

C# application (WPF on .Net 8) using excel COM interop ("automation") which adds a menu in the Excel application and setsup a click handler (in WPF).

All works normally just fine, but when debugging and say dwelling a couple of minutes (1.5 to be more specific) at a breakpoint in the click handler code, Excel pops up a Ok/Cancel dialogbox stating "Microsoft excel is waiting for another application to complete an OLE action".

if I continue my code with this box still not Ok'ed or Cancelled (which is quite easily happening), the next call to Excel, e.g. Microsoft.Office.Interop.Excel.Application.ScreenUpdating = false; this call throws a COMException (0x800AC472).

If the dialog was closed before proceeding handler code all is fine.

This seems to happen with "all" calls to Excel while dialogbox is open (Ok, I haven't tested with all calls of course, but some).

This upsets my debugging session and I would like Excel to not behave like this, at least something which could be compiled only when debug mode.

Anyone have some hints?

Answer 1

I‘d suggest you create a new thread in Office Development which is special channel to handle such issue.

Office Development - Microsoft Q&A

Thank you for your understanding.

Answer 2

Thanks, moved to https://learn.microsoft.com/en-us/answers/questions/1659707/com-timeout-excel