Menu
I wrote an Excel VBA add-in over ten years ago, which uses the old Commandbars to put a menu in Excel's Tools menu (in Excel 2003 and earlier) or in Excel's Add-Ins tab (in Excel 2007 and later). I've never had a problem with the menu appearing, in all versions of Excel from 97 through 2013.But now a user says Excel Add-Ins menu not appearing for him in Excel 2013. Normally that means the add-in isn't loaded, but in his case the add-in is loaded and working. We know the add-in is loaded and working because the add-in adds user-defined worksheet functions, and those UDFs are working fine for him. But he wants to get to the add-in's menu and can't.My googling showed that some people are having trouble with the Add-Ins menu in 2013, but I didn't find anything specific to this problem.Yes, he's tried enabling the Add-Ins tab in Excel Options Customize the Ribbon.BTW this is an.xla add-in, not a COM add-in.Any suggestions? I had a similar problem where two.xlam files that loaded and appeared in custom ribbon tabs in Excel 2010 didn't show up in the ribbon in Excel 2013 even though they were loading each time a workbook was opened. I tried all sorts of solutions - disabling the Analysis Toolpack, disabling and enabling the.xlam files, making sure the.xlam's attached XML file was up to date (I was thinking an MSO image I had in the XML code was no longer available in Excel 2013), but nothing worked.
I eventually tried copying and renaming the.xlam file and enabled it in Excel and, strangely, it appeared in the ribbon.I have no idea why it needed to be copied and renamed - it's almost like Excel 2013 needed a fresh copy of the.xlam file before it could show up. Had a similar problem in Excel 2010. Tried all the suggestions above, but to no avail. In the end it turned out that even though it was an.xll add-in, it somehow also was listed as a COM add-in. So going to File Options Add-In, then selecting Disabled Items from the list at the bottom of that window and enabling the add-in, worked for me. Now in the list of Active Application Add-ins it shows both the original Excel Add-in, and the unexpected COM add-in without location.
Oh, and the tab is back of course.
Click the File tab, click Options, and then click the Add-Ins category. In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears. In the Add-Ins available box, select the check box next to the add-in that you want to activate, and then click OK. Where Can I Download The Megastat Add-in For Excell - Excel: View Answers. I would like it to keep a running tab, so as I add in the person's attendace it will continue that count, up to the 26 classes that are being offered. I thought if I did a sumif/countif I could get it to work, but it doesn't. I am running Excel 2011 for Mac.
Getting Megastat NOTE: YOU MUST TRY TO INSTALL MEGASTAT BEFORE THE TUTORIAL CLASS step 1Go to the to download and install the Megastat Excel add-in needed for class.Choose the install line apprpriate for your computer and operating system.