Macabacus and Microsoft (for the most part) no longer support Internet Explorer 10 and prior versions. Please consider upgrading your browser.

Troubleshooting

Known Issues

This section of the documentation primarily describes problems resulting from Microsoft Office updates that introduce bugs or other changes that break Macabacus or Macabacus Lite functionality, and generally does not include problems involving Macabacus add-ins themselves, as we fix bugs in the full version of Macabacus promptly upon discovering them.

Excel data may be deleted unexpectedly

In August or September 2017, Microsoft released an Office update that introduced a bug that may cause Excel 2016 purchased via an Office 365 subscription (only) to delete data unexpectedly after saving when Macabacus' AutoColor on Entry is enabled. This bug was discovered in Office 2016 build 8326, and may be present in other builds. It is believed that you will only encounter this problem if you see the AutoSave option (enabled or disabled) in the top left corner of the Excel window. To avoid this bug, you can disable AutoColor on Entry (which is disabled by default). We have reported this bug to Microsoft and they have acknowledged it. We will report any updates here.

Some Macabacus dialogs do not respond to keyboard input

If some Macabacus dialogs do not respond to keyboard input, another add-in may be causing this condition with low-level keyboard hooks that "hijack" your keyboard. While keyboard hooking has legitimate uses, it should never interfere with the operation of other software. We have observed this conflict only with Workshare's Excel add-in, specifically, although other add-ins might produce the same result. Disable the Workshare or other conflicting COM add-in to resolve the problem, and report the problem to that add-in's manufacturer. This issue seems to affect only modeless Macabacus dialogs (e.g., Pro Precedents/Dependents), not modal dialogs.

Macabacus Lite not loading upon starting Excel

In July 2016, Microsoft released a flawed Office security update that prevents many VBA add-ins (including Macabacus Lite) from loading when starting Excel 2016, 2013, or 2010. This update leaves hundreds of thousands (or more) of Excel users wondering why their add-ins are suddenly not loading.

Update — This issue can be resolved by changing how you install/load VBA add-ins. Please see our updated Macabacus Lite installation instructions for more information. Commentary from Microsoft suggests that they may reverse some of these changes to avoid further confusion, and we will update the installation instructions as required if they do.

Saving triggers Undo in Excel 2016

In June 2016, Microsoft released an Office update that introduced a bug that may cause Excel 2016 (only) to undo the last change when saving workbooks with Macabacus' AutoColor on Entry feature enabled. In response, we promptly released a workaround in Macabacus v8.1 that disables AutoColor on Entry and clears Excel's undo stack upon saving. To avoid clearing Excel's undo stack upon saving, you can disable Macabacus Undo. Alternatively, in older versions of Macabacus for Excel 2016, you can disable both Macabacus Undo and AutoColor on Entry as a workaround.

Update — Microsoft released a fix for this bug in a subsequent Office update in late July 2016. Install Macabacus v8.2.0 or later, and install the Office update to get the fix.

Erratic behavior in Excel 2013

A serious Excel 2013 bug introduced in Microsoft Office update KB3085502 in September 2015 affecting Office builds 4753 and 4763 can make add-ins—including some Macabacus features—behave erratically.

Update — Microsoft update KB3101499, released on November 10, 2015, fixed this bug in Office build 4771. Update Office 2013 to build 4771 or later to get the fix.

This documentation refers to Macabacus version 8.8.15, and may differ from the PDF documentation
on your computer that installed with your version of Macabacus.