Solved

Excel 2013 - Addin

Posted on 2013-11-05
1
573 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
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 …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

863 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

18 Experts available now in Live!

Get 1:1 Help Now