Excel Add-in Dialog open gives ""An internal error has occurred." error

Question

I have an Excel Add-in using shared runtme which has some ribbon buttons and one of the ribbon button is used to open a dialog. However if user clicks this button frequantly, I am getting this error ""An internal error has occurred." and no page is loaded in dialog. Even right click on dialog does not show context menu which is usually shown when page is loaded. First image shows empty dialog opened.

Second Image shows debug breakpoint hit and error message I got in host taskpane. asyncResult.error.code has value "-2147467259".

Any idea how to avoid this situation?

EDIT: code in ribbon event handler:

if(dialog)dialog.close();// close previously opened dialog. here dialog is reference of previously opened dialog if any
Office.context.ui.displayDialogAsync(urlp,
        { height: height, width: width, displayInIframe: true }, dialogCallbackIFrame);

event.completed();

What code do you have in the ribbon button's event handler? Did you try to just display a dialog box without any additional code? — Eugene Astafiev
– Eugene Astafiev, Commented Feb 10, 2023 at 22:54
@EugeneAstafiev I have updated question with code in ribbon event handler. — Kashif
– Kashif, Commented Feb 14, 2023 at 19:19

Eugene Astafiev · Accepted Answer · 2023-02-14 19:31:54Z

1

You need to wait a bit until the previous dialog is closed. Try to add some delay before calling the displayDialogAsync method.

answered Feb 14, 2023 at 19:31

Eugene Astafiev

49.8k3 gold badges28 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kashif Over a year ago

I will try to add a delay, however as per documentation there is no way to know how much delay should be added and if previous dialog is not closed and next dialog open call will send 12007 error, in this case I called Open dialog function again as shown in 2nd image in question. and this approach is working if user does not click ribbon button so fast.

Eugene Astafiev Over a year ago

True, but I've found that increasing the delay between attempts may help.

Kashif Over a year ago

even though delay has not eliminated problem, but it has significantly reduced its occurrences.

Collectives™ on Stack Overflow

Excel Add-in Dialog open gives ""An internal error has occurred." error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related