File Operations

Macabacus' workbook optimization tools keep your models healthy, reducing file size and improving stability and performance. As a rule of thumb, workbooks should generally remain below 1Mb in file size (unless they include huge data dumps). Larger file sizes often indicate a problem that Macabacus can fix.

These tools can be accessed under the Macabacus > File > Optimize menu of the Macabacus ribbon.

Your models can accumulate numerous defined names over time, potentially reaching tens of thousands. This increases file size, destabilizes workbooks, and slows operations. Many of these names, often added by data add-ins, remain hidden and unused, and Excel's Name Manager doesn't display them making management difficult. Excessive names can even prevent Name Manager from opening.

Macabacus' Name Scrubber addresses this by showing hidden names and allowing safe deletion without #REF! errors. It can remove all range names with broken references (#REF!), unused names referring to constants or arrays, and all hidden names, efficiently handling tens of thousands in under a minute.

Workbooks can accumulate thousands of unused Excel styles, bloating file size and causing instability. The limit of 65,000+ styles is often reached, and Excel's native deletion is slow and tedious. Macabacus' Style Scrubber allows bulk deletion via the Macabacus > File > Optimize menu.

Unlike free utilities, which can't delete corrupt styles and remove all custom styles indiscriminately, Style Scrubber identifies used and unused styles to prevent errors. If it fails to delete a corrupt style, indicated by non-standard characters, Macabacus prompts a Deep Clean to remove these styles by copying the workbook and cleaning the copy.

_{This documentation refers to the latest Macabacus version. 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.}