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

General Usage Tips

The following guidelines are recommendations for using Microsoft Office with Macabacus, specifically; using Office with add-ins, generally; or using Office, generally.

System Font Size

To ensure proper display of Macabacus user interfaces (e.g., dialogs), ensure that your Windows system font is set to Microsoft's "recommended" size—the smallest, 100%, 96 dpi size. To change your system font size, open Windows' Control Panel, navigate to Appearance and Personalization > Display, and move the font size slider all the way to the left. Unfortunately, Microsoft makes supporting larger font sizes extraordinarily difficult, and some Macabacus interfaces may appear distorted or clipped at larger font sizes.

Multiple Instances

For reliable performance, ensure that only a single instance of each Office application (i.e., Excel, PowerPoint, and Word, as applicable) is running. To do this, go to the Processes tab (Windows 7) or Details tab (Windows 8, 10) in Task Manager and confirm that excel.exe, powerpnt.exe, and winword.exe appear only once. Add-ins cannot reliably determine to which instance of an Office application to refer when multiple instances are running. Some Macabacus tools display a warning message when multiple instances are detected, while others may fail silently.

Multiple instances are most common in Excel 2010 and earlier versions, where they are sometimes used to display workbooks in separate windows that can be viewed simultaneously on different monitors. Subsequent versions of Excel use a single document interface (SDI) that displays workbooks in separate windows with their own interfaces, largely eliminating any need for multiple instances. Indeed, it is difficult to run multiple instances of Office 2013 and later applications, so multiple instances are rarely a problem in newer Office versions.

Windows 7 Task Manager Windows 10 Task Manager

Terminal Servers

When running Office applications in a terminal server or Citrix environment, rather than locally, multiple running instances of Office applications are common. When Macabacus detects these environments, it ignores multiple instances to allow the requested operation to proceed. However, this may result in unexpected behavior if Macabacus cannot determine to which instance to refer.

Elevated Applications

If one Office application is running with elevated privileges (i.e., run as administrator) while another is not, the two apps will not be able to "see" each other (for example, when exporting from Excel to PowerPoint). If Macabacus reports that an Office application is not open, even though it clearly is, check whether one app is running with elevated privileges while the other is not.

Interoperability Between Applications

Some Macabacus operations involve cross-communication between Office applications, such as updating PowerPoint shapes linked to Excel. While Macabacus will start Office applications when required if they are not already running, it is preferable—for performance and stability—to have the required Office applications running already, before Macabacus requires them.

SharePoint

Do not open Office files read-only from SharePoint. Unfortunately, read-only may be the default in your environment, but you should explore the many workarounds described on the Internet.

Protected View

Most add-in operations are unavailable while workbooks, presentations, and documents are open in Protected View, indicated by a yellow warning bar below the ribbon.

Protected View

Worksheet Protection

Some Macabacus tools may not behave as expected when the worksheet on which they are performing an operation is protected. Some Macabacus tools prompt you to unprotect sheets, and others do not. If you unprotect a worksheet after being prompted by Macabacus to do so, Macabacus cannot re-protect the sheet after the operation is complete. Protection must be manually reapplied.

Shared Workbooks

Do not share workbooks using Excel's native sharing capability (Review > Share Workbook). Shared workbooks suffer a loss of functionality and create problems for add-ins trying to work with them. Shared workbooks display "[Shared]" in the application window title.

Windows Explorer Preview Pane

When you select a presentation in Windows Explorer with preview pane enabled, Windows Explorer appears to open the presentation in a hidden window. This mysteriously prevents PowerPoint add-ins from working with that presentation. We consider this a Windows bug, as the same issue is not observed with Excel workbooks and there is no logical reason for this behavior.

Cell Selection

Limit the cells in your selection to those cells with which you actually need to work before performing certain Macabacus operations. Macabacus may inspect or modify each cell in your selection individually, and when you select an entire column to modify a single cell in that column, for example, the operation may take longer than necessary.

Undo/Redo

Some Macabacus formatting operations may be noticeably slower with Macabacus Undo/Redo enabled, with speed inversely proportional to the number of cells affected by the operation. The performance hit from using Undo/Redo can be mitigated by limiting the number of cells in your selection as described above. Disable Undo/Redo if it is unacceptably affecting performance.

Calculation Settings

For optimal Excel performance in most scenarios, use the following calculation settings:

  • Calculation mode set to "Automatic except for data tables";
  • Iterative calculation enabled;
  • Maximum iterations set to 100.

Some Macabacus tools disable calculations while performing computationally intensive operations, and then re-enable calculations when complete. Other Macabacus tools do not. If Macabacus seems to be slowing down Excel, ensure that your calculation settings are configured as above.

UNC Paths

IT professionals should note that Macabacus generally works better with mapped drive paths than raw UNC paths, although we are aware of no particular instances in which UNC paths cause problems.

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