Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel 2013 - Addin

Posted on 2013-11-05
1
Medium Priority
?
639 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 2000 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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

604 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