Solved

Excel 2013 - Addin

Posted on 2013-11-05
1
567 Views
Last Modified: 2014-05-06
We have an Excel Addin, developed by someone who left a long time ago that runs fine in Excel 2010 and before, but I can't get it working in Excel 2013. Although it does work in Excel 2013 on one machine which is 32bit.

We're running 32Bit versions of Office 2013.

The installer puts the XLA in c:\programs 86\etc\etc

When I add it, it adds fine, however when we try and use it Excel compains that

"Cannot run the macro  'nameoftheaddin.xla!!InsertFormula'. The Macro may not be available in this workbook or all macros may be disabled"

I have been through all the settings in the trust centre but that doesn't make any difference.

Any pointers would be great.

Cheers

Ed


<<Question de-indexed because I believe Asker chose to close the question rather than engage in dialog with Expert. The questions asked by Expert are appropriate, and would lead to an Answer if the Asker responded to them.--byundt, Microsoft Excel Topic Advisor 5-6-2014>>
0
Comment
Question by:edwalters
1 Comment
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 500 total points
ID: 39626747
Hi,

...Although it does work in Excel 2013 on one machine which is 32bit.

We're running 32Bit versions of Office 2013.

Just to confirm:

Are all your PCs using 32-bit versions of MS-Office 2013 installed in a 32-bit version of MS-Windows?

Also,...

"Cannot run the macro  'nameoftheaddin.xla!!InsertFormula'. The Macro may not be available in this workbook or all macros may be disabled"

Are there really two exclamation points in the error message (...xls!!InsertFormula...) ?

Does the PC where the Add-in is functioning correctly have fewer Add-ins loaded concurrently than the other environments?

Is there the possibility that "InsertFormula" is already defined in the environments where the Add-in cannot run?

Can you provide (attach) the Add-in to this thread, or perhaps a cut-down version of the function you are trying to call that does not perform any statements other than returning to the calling process?

In fact, have you tried this in your own environments?  Reducing the "InsertFormula" function to the most basic number of statements, or renaming it (& changing the references where the function is called from) to see if there is an issue with a duplication of function names?

BFN,

fp.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now