Solved

Excel 2013 - Addin

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

803 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