Macabacus and Microsoft (for the most part) no longer support Internet Explorer 10 and prior versions. Please consider upgrading your browser.
Understanding whether Macabacus simply failed to load in Office applications, or failed to install in Windows at all, is important. The latter scenario is very uncommon, but can be confirmed by inspecting your list of installed programs in Windows' Control Panel. If Macabacus appears in that list, then installation was likely successful and Macabacus simply failed to load properly. Follow the troubleshooting steps applicable to your situation below.
There are two Macabacus add-ins for Excel. The VBA add-in named Macabacus.xlam can generally be ignored for troubleshooting purposes unless an error message specifically references this file. The VSTO add-in, which appears in Excel's COM Add-Ins dialog, implements most Macabacus functionality, including the Macabacus tab in the ribbon.
Do not attempt to open the Macabacus .vsto files located under the Program Files folder in an effort to force the Macabacus tab to appear in Office applications, unless directed below. This will not solve your problem, and may create other issues.
If the Macabacus tab is missing from the ribbon in one or more Office applications, then it is probable that the Macabacus VSTO add-in failed to load. The following steps will normally resolve this problem. Substitute "PowerPoint" or "Word" for "Excel" as applicable.
PLEASE DO NOT SUBMIT A SUPPORT REQUEST UNTIL ALL 10 STEPS ARE PERFORMED EXACTLY AS DESCRIBED HERE.
Check the Excel's COM Add-Ins dialog and check the Macabacus 20XX box if unchecked. If you do not see Macabacus listed here, skip to step #4.
Check the Excel's Disabled Items dialog and re-enable Macabacus if disabled. Repeat step #1 if necessary.
Check Task Manager (Details tab in Windows 8 and newer) to confirm that only a single instance of the Excel is running. If multiple instances are running, quit them all and restart Excel.
Open Registry Editor and navigate to
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Macabacus20XX. If the LoadBehavior value is 0, change it to 3. To open Registry Editor, type
regedit in Windows' Run prompt (
Confirm that the full desktop edition of Office is installed locally by checking for the presence of the
InstallRoot registry key pictured below. If this key is missing, you must install Office locally. See Macabacus' system requirements for more information.
In Windows Explorer, navigate to the folder
C:\Program Files (x86)\Macabacus\Macabacus 20XX, or its equivalent on your PC. Double click the file named
If a resulting error message reads something like "Unable to install this application because an application with the same identity is already installed...", navigate to the folder
C:\Users\%USER NAME%\AppData\Local\Apps\2.0 and delete all files and sub-folders related to Macabacus there. Then, uninstall and reinstall Macabacus.
If a resulting error message reads "The following Microsoft Office solution cannot be installed due to a general installer error..." with error code 0x8007007E, then confirm that you have installed the VSTO Runtime prerequisite per step #4 above.
Additionally, include the outcome of each step above not addressed through the aforementioned screen shots.
Confirm that you have the full desktop edition of Office installed locally by checking for the presence of the
InstallRoot registry key pictured below. See our system requirements for more information.
If Macabacus failed to install properly in Windows, perform the following troubleshooting steps:
File > Options > Add-Ins. In this dialog, select COM Add-Ins from the dropdown menu and click Go. If Macabacus appears in the list of COM add-ins shown here (but is presumably unchecked), then your problem is more likely that Macabacus failed to load. In this case, perform the troubleshooting steps above for "The Macabacus tab disappeared or is not visible."
MsiFFFFF.log(or something similar) located in the Temp folder to email@example.com. Check the Date Added property of the log file to be sure you have the correct log file.
If uninstalling Macabacus from within Windows' Control Panel and then reinstalling does not resolve this issue, see this link.
In general, most problems involving the Macabacus.xlam add-in can be resolved by pointing Excel to the correct location of this file. Normally, you can do this using Excel's Add-Ins dialog. If this approach fails, you may need to manually set the correct path to Macabacus.xlam in the registry.
Perform the following steps to resolve this issue:
Macabacus.xlamfile exists at the path shown in the error message. If it does not, reinstall Macabacus.
Alt>T>I), uncheck Macabacus if already checked, and click OK to close the dialog. Then, open the dialog again and click the Browse button to find
Macabacus.xlamat the path shown in the error message. Be sure Macabacus is now checked, and click OK to close the dialog. Office can be finicky about changing the paths of add-ins, so you may need to try this, and restart Excel a few times for it to stick.
Macabacus.xlamusing the Registry Editor. The registry key should be
HKEY_USERS\Software\Microsoft\Office\15.0\Excel\Options, or something similar, depending on your version of Office.
This may occur if you have recently upgraded (or downgraded) Microsoft Office. Macabacus for Office 20XX looks for the XLAM add-in referenced above in
C:\ProgramData\Macabacus\Macabacus 20XX. For example, if you upgraded from Office 2013 to Office 2016, but still have Macabacus for Office 2013 installed, Macabacus looks in
C:\ProgramData\Macabacus\Macabacus 2016 for the XLAM but cannot find it, producing this error. In addition, Excel stores the path to the XLAM in the registry. When you upgrade from Office 2013 to 2016, Excel might still look in
C:\ProgramData\Macabacus\Macabacus 2013 for the XLAM add-in. Sometimes, the only way to tell Excel the correct place to look is by editing the registry manually.
Alt>T>I) and select the Macabacus add-in. You may receive a prompt asking you to delete it. If so, click OK and then exit the dialog by clicking OK.
Perform the following steps to resolve this issue:
Alt>T>I), uncheck the Macabacus add-in, and click OK.
Macabacus.xlamfile in the location shown in your error message. You may receive a Yes/No/Cancel prompt from Excel asking you to replace the
Macabacus.xlamfile. If so, click Yes.
Macabacus > Settings > Keyboardand click the Override button. Your Macabacus shortcuts should now be working correctly.
Trust Center > Add-ins.
If this error occurs upon starting Excel, or when trying to manually load Macabacus.xlam from Excel's Add-Ins dialog, then Excel may be installed incorrectly. Ensure that Excel is installed with Microsoft Office Tools. Try loading other add-ins to confirm this problem, if necessary.
When Macabacus.xlam is loaded upon starting Excel, Excel's splash screen may appear to freeze while loading this add-in. What is mostly likely happening is that anti-virus software (e.g., Symantec Endpoint Protection) is either blocking the add-in from loading, or causes it to load slowly while it attempts to check the add-in. If this happens, either disable the anti-virus software causing the problem, or configure it to not scan Office add-ins.
This documentation refers to Macabacus version 8.9.17. Some features and descriptions of these features may not
apply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.