Exception from HRESULT: 0x800A9C68

[bovender]

This issue was submitted by the add-in's exception handler.

Exception:

System.Runtime.InteropServices.COMException (0x800A9C68): Exception from HRESULT: 0x800A9C68
   at Microsoft.Office.Interop.Excel._Application.Run(Object Macro, Object Arg1, Object Arg2, Object Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14, Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25, Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)
   at XLToolbox.Legacy.LegacyToolbox.RunCommand(Command command) in XLToolbox\Legacy\LegacyToolbox.cs:line 195
   at XLToolbox.Dispatcher.ErrorBarsInteractive() in XLToolbox\Dispatcher.cs:line 388
   at XLToolbox.Dispatcher.Execute(Command cmd) in XLToolbox\Dispatcher.cs:line 80

Message: Exception from HRESULT: 0x800A9C68

Environment

Parameter	Value
Version	7.3.2
OS	Microsoft Windows NT 6.1.7601 Service Pack 1, 32-bit
Excel	2010 SP2 (14.0.7190), 32-bit
CLR	4.0.30319.42000, 32-bit
VSTO runtime	10.0.40305
ClickOnce	False
Bovender	0.17.3.0
FreeImage	3.18.0
Identifier	d462ea297eb7072dd07cc4697e2f6f83c67cfb4e77e25a0fd5fc97cd522f2e19

[ramadeyrao]

Please let me know if the screen shot above is enough to troubleshoot. Thank you for the help. Rama Dey-Rao

[bovender]

Thanks. In the VBA window, could please do the following:

1. Double-click on an arbitrary form, e.g. "Form_2WayAnova".
2. Ensure that "Toolbox" in the "View" menu is activated (there should be a little palette with "Controls" visible). Usually, the Toolbox palette is opened automatically.
3. In the "Tools" menu, click on "Additional controls...".
4. In the list that appears, scroll way down and locate "RefEdit Ctrl".

Do you see the "RefEdit Ctrl" item? Is it checked?

The error that you see ("RefEdit_Range" not being a variable that is defined) is really strange. Do you have a full installation of Office? Or is this some sort of company setup where Office may be stripped down (and hence, lacking this user interface control).

[ramadeyrao]

Hi Daniel,

I went through the entire process including a complete download of the latest Microsoft Office etc. Then went through every step of what you detailed below and saw that the "RefEdit Ctrl" was checked with a cross sign. I also asked an IT person to check and see that I had the whole install of Microsoft Office 2016. Everything looks fine but the tool still gives me the same error. It does do the auto detect on adding the error bars but does not work on the interactive function and gives me the same error as I sent you the screen shot of. It always worked even three months ago.

So if you can help me I would truly appreciate it.

Rama Dey-Rao

From: Daniel Kraus notifications@github.com Reply-To: bovender/XLToolbox reply@reply.github.com Date: Tuesday, September 18, 2018 at 3:27 PM To: bovender/XLToolbox XLToolbox@noreply.github.com Cc: Rama Dey-Rao dey@buffalo.edu, Comment comment@noreply.github.com Subject: Re: [bovender/XLToolbox] Exception from HRESULT: 0x800A9C68 (#715)

Thanks. In the VBA window, could please do the following:

1. Double-click on an arbitrary form, e.g. "Form_2WayAnova".
2. Ensure that "Toolbox" in the "View" menu is activated (there should be a little palette with "Controls" visible). Usually, the Toolbox palette is opened automatically.
3. In the "Tools" menu, click on "Additional controls...".
4. In the list that appears, scroll way down and locate "RefEdit Ctrl".

Do you see the "RefEdit Ctrl" item? Is it checked?

The error that you see ("RefEdit_Range" not being a variable that is defined) is really strange. Do you have a full installation of Office? Or is this some sort of company setup where Office may be stripped down (and hence, lacking this user interface control).

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/bovender/XLToolbox/issues/715#issuecomment-422518296, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ApVniVPR6V7CZjENL1f8Ohyy5L7hIlLqks5ucUkVgaJpZM4Wr-Ph.