Solved

Excel 2013 - Addin

Posted on 2013-11-05
1
605 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

688 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