AddIn installed and shows up in Excel AddIn list

[Yinru Hou]

but no ribbon shows up at all,
If I check the addin list, there is no COM AddIn available either.
Not sure how to debug this on client machine.

I use fusion.exe, it seems there is log at all.

thanks

[Govert van Drimmelen]

Hi Yinru,

From your message it sounds like the add-in works normally, and not on
this particular machine?
Easiest might be to compare the machine where it doesn't work with a
machine that does work.

* You might check the security settings in the Trust Center under
Excel's options.
* Do simple Excel-DNA add-ins work on the machine (say an add-in with
just some UDFs)?
* Check one of the simple Ribbon samples in the Excel-DNA
distribution.

-Govert

[Yinru Hou]

thanks. Govert.
It works on some machines but one machine got the issue, the other machine has "Error 1004 unable to set the installed property of the addin class"
I checked security settings on the machine (on which no addin show up, no 1004 error) and it looks fine.

Will try as you suggest. thanks

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To post to this group, send email to exce...@googlegroups.com.
To unsubscribe from this group, send email to exceldna+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/exceldna?hl=en.

[Yinru Hou]

Hi, Govert:
I think Error 1004 may be related to path issue. but not sure.

I webex with users and watched his install, no 1004 error any more.  My addin installs successfully.
All UDFs works. However, Ribbon does not show up at all.   My addin shows up in active addin list, but My addin (Ribbon Helper) is always put in disabled AddIn.
I click to enable it but no influence at all.

I also tested with the simple Ribbon samples in the Excel-DNA distribution, the same thing happened i.e. its Ribbon Helper is always put in disabled AddIn

One thing I notice the user has .NET 4 client profile, no other .NET framework on his PC, OS is win 7 (32 bit),
My addin requires .NET 35 SP1 though.

But I do see this environment works fine for previous version of My AddIn (before using ExcelDNA)

I have no idea what to check/test

thanks

[Yinru Hou]

Anyone else has tested on win 7 32bit + Excel 2007?
I tested a simple ribbon from distribution folder, it does not work, no ribbon shows up.
and Ribbon Helper is always put in disabled addin

thanks

[Govert van Drimmelen]

Hi Yinru,

In general, Excel-DNA certainly works with Windows 7 (32-bit) + Excel
2007.

If your add-in requires .NET 3.5 SP1, and only .NET 4 is installed, it
will not work.

To explicitly specify that your add-in should use .NET 4, add a
<DnaLibrary RuntimeVersion="v4.0" >
attribute in the .dna file.
(You should get a nice error message though, so I think at least .NET
2.0 must be installed.)

It would be very strange for the PC to not have .NET 3.5, since it is
installed with Windows 7 (not sure whether SP1 is).
How did you check when you say ".NET 4 client profile, no other .net
framework"?

The 1004 error with the message "unable to set the installed property
of the addin class" does not come from the Excel-DNA code - it muyst
be from some aspect of your installer.

Can you confirm whether the simple Excel-DNA sample add-in in the
distribution works (i.e. just the ExcelDna.xll + ExcelDna.dna files
from the distribution directory of Excel-DNA version 0.29.)?
If not, I suggest you check whether VBA works on that Excel
installation (just press Alt+F9).

-Govert

[Yinru Hou]

Thanks.  Govert.
I checked .NET framework in control panel -> Program
I only see .NET framework 4 client profile there. 
I can see all UDFs works fine only Ribbon UI does not show. this is true for simple TestRibbon from distribution folder, too.

thanks

[Yinru Hou]

Hi, Govert:
I just checked Computer\HKEY_LOCAL_MACHINE\Software\Microsoft\.NETFramework\Policy in Registry
It has v2.0, v4.0 there.  and Ribbon shows up and I do not even know why.

However, there is another user reported the same issue.
I installed .NET 35, .NET 4. on the second user's PC and tried the simple ribbon test.
It does not show up at all.  I ran a simple macro, it works.
So not sure what else to check


thanks

[Yinru Hou]

To make it more clear,
one end user has installed my addin successfully but no Ribbon UI shows up at all.
I saw he's only has .net 4 client profile, so I manually installed .net 4 extented, & .net framework 35 sp1,
but Ribbon UI still does not show up.   My addin (Ribbon Helper) is put in disabled addin.

I check that VBA works, simple ribbon test from distribution does not work, either. Ribbon Test(Ribbon Helper) is put in disabled addin.

thanks

[Yinru Hou]

Yes, simple Excek-DNA addins work on the machine (addin with just some UDFs)
but AddIn with Ribbon does not work or partially work, i.e. everything works just no Ribbon

thanks

On Tue, Aug 23, 2011 at 1:58 PM, Govert van Drimmelen <gov...@icon.co.za> wrote:

[Govert van Drimmelen]

Hi Yinru,

Are there any other COM add-ins loaded in that Excel.
* If there are, can you disable all of them, restart and then try the
sample from the distribution.
* If not, could you try another COM add-in?

Do other add-in ribbons work on that machine?

Can you check the regional and language settings on the machine?

I cannot remember any similar report of the Ribbon sample not loading.
On how many machines have you deployed your add-in before seeing this
problem?

-Govert

On Aug 25, 6:40 pm, Yinru Hou <yinru...@gmail.com> wrote:
> To make it more clear,
> one end user has installed my addin successfully but no Ribbon UI shows up
> at all.
> I saw he's only has .net 4 client profile, so I manually installed .net 4
> extented, & .net framework 35 sp1,
> but Ribbon UI still does not show up.   My addin (Ribbon Helper) is put in
> disabled addin.
>
> I check that VBA works, simple ribbon test from distribution does not work,
> either. Ribbon Test(Ribbon Helper) is put in disabled addin.
>
> thanks
>
>
>
>
>
>
>
> On Thu, Aug 25, 2011 at 11:35 AM, Yinru Hou <yinru...@gmail.com> wrote:
> > Hi, Govert:

> > I just checked
> > Computer\HKEY_LOCAL_MACHINE\Software\Microsoft\.NETFramework\Policy in
> > Registry
> > It has v2.0, v4.0 there.  and Ribbon shows up and I do not even know why.
>
> > However, there is another user reported the same issue.
> > I installed .NET 35, .NET 4. on the second user's PC and tried the simple
> > ribbon test.
> > It does not show up at all.  I ran a simple macro, it works.
> > So not sure what else to check
>
> > thanks
>

[Yinru Hou]

I just checked %WINDIR%windows\Microsoft.NET\Framework, it has all versions of .NET, 1.0, 1.1, 2.0, 3.0, 3.5, .4.0
it seems .NET framework is installed, not sure why Ribbon not show up.

I just uninstalled my addin and try again, this time, Ribbon UI shows up!  This is so confusing, not sure what happened!?

thanks

[Yinru Hou]

There is no other COM AddIn loaded in that Excel

I installed my addin of earlier version (which was a com addin no Excel DNA), it works fine

regional is US, language is English(US)

I put my addin on website,  sales people just download it from there and install

As far as I know, a few customers, two sales guy, QA team, Business Analysis team downloaded  addin
Two sales guy have the issue, a couple of customers have the same issue

thanks

[Govert van Drimmelen]

Hi Yinru,

Are you very sure the "Disable notification for unsigned add-ins (code will remain disabled)" setting is not on for the machine which gives problems?

-Govert

[Yinru Hou]

Hi, Govert:

I double check it, the option is unchecked.

thanks

[Yinru Hou]

This issue must be very subtle and hard to reproduce.
I asked SA to create the same environment (Win 7 32 bit + Excel 2007) as the end user does for me to test/debug, Unfortunately I can't reproduce the issue on the newly created VM image or laptop SA provided to me.
 
I suspect this may be related to some Microsoft or .NET framework settings which I am not able to identify

and I can't make end user's PC to go back to the status where My addin did not show up

Have no clue or idea what to check or where to go next

thanks

[Govert van Drimmelen]

Hi Yinru,

You could experiment a bit with the different options in the Trust
Center.

I would expect that the setting "Require Application Add-ins to be
signed by Trusted Publisher" and "Disable notification for unsigned
add-ins (code will remain disabled)" - both in the Add-Ins tab of the
Trust Center, together with "Enable all macros (...)" under the Macro
Settings tab would give the behaviour you report.

However, in my experiments I always get the Ribbon when the add-in
UDFs are loaded.
One difference might be if the Ribbon add-in is registered differently
or in a separate library.

I still find the Office security beyond my understanding.
If you can set up a repeatable case which you don't understand, I'd be
happy to look further.

Regards,
Govert

On Aug 26, 10:21 pm, Yinru Hou <yinru...@gmail.com> wrote:
> This issue must be very subtle and hard to reproduce.
> I asked SA to create the same environment (Win 7 32 bit + Excel 2007) as the
> end user does for me to test/debug, Unfortunately I can't reproduce the
> issue on the newly created VM image or laptop SA provided to me.
>
> I suspect this may be related to some Microsoft or .NET framework settings
> which I am not able to identify
>
> and I can't make end user's PC to go back to the status where My addin did
> not show up
>
> Have no clue or idea what to check or where to go next
>
> thanks
>
>
>
>
>
>
>
> On Thu, Aug 25, 2011 at 5:04 PM, Yinru Hou <yinru...@gmail.com> wrote:
> > Hi, Govert:
>

> > I double check it, the option is unchecked.
>
> > thanks
>
> > On Thu, Aug 25, 2011 at 4:52 PM, Govert van Drimmelen <gov...@icon.co.za>wrote:
>
> >> Hi Yinru,
>
> >> Are you very sure the "Disable notification for unsigned add-ins (code
> >> will remain disabled)" setting is not on for the machine which gives
> >> problems?
>
> >> -Govert
>

> ...
>
> read more »

[Ib]

Hi,

I have experienced a similar problem with a word add-in being loaded
but always showed up disabled, and it was not possible to enable it.

The solution was to delete a registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Resiliency
\DisabledItems
After that we didn't have the problem again.

Regards,
Ib

> > >>>> exce...@googlegroups.com.- Hide quoted text -
>
> - Show quoted text -...
>
> read more »

[Yinru Hou]

thanks, lb. 
I can't reproduce the issue. Next time I will try the solution.

thanks for sharing

Yinru