C# Excel Addin not Loading in Excel 2000

Question

0.00/5 (No votes)

See more:

Dear Friends,

I am creating a Shared Addin Using VS 2005 for Excel. (File --> New Project --> Other Projects -- Extensibility --> Shared Addin.
I am having both Excel 2007 and Excel 2002(Office XP) installed in my system, the Addin works fine with both the excel version.

When I install the Addin setup in some other sytem the addin is not loading.
How to deploy the addin for all the Excel Versions?

Posted 25-May-11 3:25am

Member 4312989

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

S Houghtelin · Answer 1 · 2011-05-25T03:34:00

Assure that all the versions of Excel you intend to allow are being referenced in the project.

Then attempt to load the addin starting with the reference to newest version of Excel, if that reference is not there (You'll know when it generates an error.) then move on down the list.

Regards.

Update:
From Microsoft. "Microsoft discourages using managed code in Office 2000 or in Office XP. Be careful when you try to introduce managed code into these Office versions. These Office versions were designed and tested before the .NET Framework was created." (http://support.microsoft.com/kb/948461[^])

So the short answer is, no. C# addins will not work in Excel 2000.

There are work-arounds and it seems there are number of forums that discuss this very problem but it seems to be a lot of effort to support the older versions.

Hemant__Sharma · Answer 2 · 2011-05-25T03:38:00

you will need to add the installation folder in ~~GAC~~ CAS with full trust on deployment machine. The development machine by default set permission for your addin to run with Office applications but on deployment you have to explicitly it.

here is a useful link for troubleshooting addins:
http://blogs.msdn.com/b/vsod/archive/2008/04/22/troubleshooting-com-add-in-load-failures.aspx[^]

Thanks,
Hemant

My bad my fingers have their own mind i wanted to type CAS but added GAC instead.
here is an additional link that talks about Outlook addin deployment but same way you can do it for excel addin
http://msdn.microsoft.com/en-us/library/cc136646.aspx[^]

Thanks,
Hemant

C# Excel Addin not Loading in Excel 2000

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0