Managed to screw up loading of ExcelDNA CustomUI

[ajwillshire]

Hi,

This is a particularly rotten way to end the week...

I have programmed an addin for Excel which uses an xml file as a
resource to load the ribbon.

This was working fine until I terminated the debugging a bit hastily.
The next time I started the debugging from visual studio a warning
popped up, along the lines of:

"Last time this resource was loaded it caused a severe memory issue.
Do you want Windows to prevent this resource from loading in future?"

I've had this before and normally just say "No" and everything is
fine. Unfortunately, this time I pressed return too quickly and it
defaulted to "Yes" thereby "protecting me".

Following this I cannot get any of the Excel-DNA programs to work if
they have a ribbon component. The functional add-ins that I have built
and the basic samples all still work (thank God!) but none of the
ribbon examples in the sample directory work (including the custom
task pane etc).

I've searched the registry for references to ExcelDNA but cannot find
any which look like it might be blocking it from loading. Even then
though, it must be loading when the function libraries are loaded so I
really have no idea what to do next.

Do you have any ideas?

Failing this, I suspect I might have to wipe the computer to try and
get back to normality.

Thanks,
Andrew

[Govert van Drimmelen]

Hi Andrew,

I only know of Excel being able to disable an add-in. The add-in goes
into a 'disabled add-ins' group in Excel and is not loaded again. I
don't know of Windows disabling the loading of a library like that.

You could check for this by going to the File->Options->Add-Ins and in
the drop-down at the bottom look for Disabled Add-Ins.

If you rename one of the Ribbon samples .dna file to some new name, so
the .xll has a new name too, I'm not sure how Excel or Windows would
decide that it's the same library that had problems before. With the
Ribbon / Custom Task Panes a COM add-in is loaded that might be
recognised by Excel somehow. So Excel seems to be blocking it at this
step.

Otherwise, do you have an anti-virus that might be 'helping'?

Let us know what you find.

Good luck,
Govert

[ajwillshire]

Hi Govert,

You were right - going to Excel\Options\Addins and then selecting
"Disabled items" from the dropdown menu brings up a window.
Interestingly, the ribbon helper for the crashed addin was listed but
this prevented the ribbon helper for any other Excel-DNA solutions
from loading.

Thanks for your help,

Andrew

> > Andrew- Hide quoted text -
>
> - Show quoted text -