Unable to load Addin in Excel 2010 64 - Bit

Add-in Express™ Support Service
That's what is more important than anything else

Unable to load Addin in Excel 2010 64 - Bit
 
VARUN GUPTA




Posts: 16
Joined: 2010-09-22
Hi,

We are using your Add-in Express dll AddinExpress.XL.2005.dll version 5.1.1189.2005 for our product to be used as COM Add-in in Microsoft Excel.

However in Microsoft Excel 2010 64 Bit (OS : Window 7 64 bit) Add In fails to initialize itself and gives exception on load i.e. when you load Add In though Excel options-> Add Ins -> COM Add In -> check on check box corresponding to Product Add In nothing happens and second time you do so there is exception written on a label in that form that unable to load Add In due to exception.

We use registry value 3/2 for specifying load behavior of Add In in the registry entry for Add In.

Can you please suggest us on ways to circumvent this issue.
Posted 24 Sep, 2010 02:34:57 Top
Andrei Smolin


Add-in Express team


Posts: 18821
Joined: 2006-05-11
Hi VARUN,

That Add-in Express version doesn't support loading into 64-bit applications from the Office 2010 suite. This is supported in Add-in Express 2010. Please pay attention that the .NET Framework 2.0 64-bit contains a bug preventing XLL add-ins based on Add-in Express from loading; in whatsnew.txt for Add-in Express 2010, that issue is described as follows:

KNOWN ISSUES
...
Excel 2010 Issues:

XLL add-in created for .NET Framework 2.0 crashes Excel 2010 x64 due to an exception in the Marshal.GetFunctionPointerForDelegate method.


That is, until that bug is fixed by Microsoft, the only way you you have is to switch to using .NET Framework 4.0. :(


Andrei Smolin
Add-in Express Team Leader
Posted 24 Sep, 2010 06:18:26 Top
VARUN GUPTA




Posts: 16
Joined: 2010-09-22
Hi Andrei,

We currently have our Application on .NET Framework 3.5 SP1.

Please provide me with some information on these queries.

1) Will upgrading the Add-In Express dll to Add-in Express 2010 and keeping our project in .NET 3.5 framework resolve the above mentioned issue?

2) Only upgrading our project to .NET framework 4.0 and retaining current Add-In dll mitigate the issue.

3) Or Both above mention steps are Mandatory for resolving the issue.

4) Or there is any other solution available.

Also if we need to have latest version of Add-In Express dll what are your policies regarding current existing customer(i.e. whether we need to purchase a new license or upgrade etc).

PS : Please feel free to send me a personal mail if you think posting such information as inappropriate.
Posted 24 Sep, 2010 06:44:53 Top
Andrei Smolin


Add-in Express team


Posts: 18821
Joined: 2006-05-11
Hi VARUN,

Upfrading to Add-in Express will allow your add-in to load in Office 2010 64-bit. To bypass the bug in .NET Framework 2.0 64-bit mentioned above, you will have to switch to using .NET Framework 4.0. Note that .NET Framework 3.5 is just an add-on for .NET Framework 2.0.

Does this answer all your questions? If not, please re-word #2 and #3 above; I miss the meaning of those questions. Sorry.

As to the upgrading policy, please see http://www.add-in-express.com/purchase/version-upgrade.php.


Andrei Smolin
Add-in Express Team Leader
Posted 24 Sep, 2010 08:24:05 Top
VARUN GUPTA




Posts: 16
Joined: 2010-09-22
Hi,

Thanks a lot for your support.

The above information provided by you do answer all my questions.
Posted 26 Sep, 2010 23:00:51 Top
Eugene Astafiev


Guest


Good news!

You are welcome, Varun!
Posted 27 Sep, 2010 03:26:16 Top