Release Notes

Version 4.0

4.0.4 (4 Feb 2012) NEW

• Performance enhancements and bug fixes.

4.0.3

• Fixed bug that sometimes prevented proper recalculation of used ranges with the Clean Up Used Ranges tool.
• Small enhancements to Quick Save and Sum Bar tools.

4.0.2

• Fixed bug preventing shortcuts from loading upon starting Excel® for some users.
• Small enhancement to Border Outline cycle.
• Minor bug fixes and enhancements.

4.0.1

• Fixed bug in Fill Color Cycle that caused problems when white fill color was present in the cycle.
• Minor Ribbon enhancements.

4.0

• Added Deep Clean option for managing defined names, providing far more powerful unused name removal.
• Added Copy/Paste Row/Column Info tools.
• Improved printable list of Macabacus shortcut keystrokes that allows sorting and easier printing.
• Ribbon now displays customized, rather than default, shortcut keystrokes.
• Ribbon now displays RGB values for colors in each color cycle.
• Improved performance of Paste Exact to more closely mimic native Excel® paste behavior.
• Improved performance of Anchor Formula cycle and expanded corresponding Ribbon functionality.
• Footnote tool now holds row height constant when adding footnotes (native Excel® behavior is to expand the row height to accommodate the footnote).
• Fixed bug related to computation of the selection range when adding footnotes.
• Minor bug fixes and enhancements.

Version 3.2

3.2

• Added new paste tools, including Paste Number Formats, Paste Links, Paste Insert, and a dedicated Paste menu on the ribbon.
• Enhanced Paste Transpose to work with new paste tools, not just Paste Exact.
• Improved Error Wrap functionality to remove bugs and deliver more predictable results.
• Minor performance enhancements.
• Dropped support for Excel® 2003; no further updates will be made to that version of Macabacus Lite.

Version 3.1

3.1.2

• Install the latest version of Macabacus Lite on-the-fly from within Excel® in just a few seconds. Your settings will be automatically preserved.
• Fixed minor bugs related to Smart Precedents/Dependents navigation.

3.1.1

• Added Right Indent Cycle shortcut and ribbon/menu button.
• Fixed bug related to Smart Precedents/Dependents navigation of worksheets with panes that caused Excel to freeze.
• Various performance and interface enhancements and bug fixes.

3.1

• Improved ribbon layout and functionality (Excel® 2007/2010 only).
• Show All Precedents/Dependents can now be toggled; repeat the keystroke or button click to show/hide trace arrows.
• Improved cell navigation with Smart Precedents/Dependents.
• Faster Paste Exact [Transpose] performance.
• Fixed a bug in Previous Worksheet Loop that affected looping backwards with hidden worksheets.
• Fixed bug affecting the Toggle Gridlines button on the ribbon (Excel® 2007/2010 only).

Version 3.0

3.0.1

• Added a Clear Arrows shortcut to accompany the Show All Precedents/Dependents keystrokes.
• Fixed a footnote toggling issue.
• Fixed a bug affecting the Show All Precedents tool in Excel® 2003.

3.0

• Added Show All Precedents/Dependents tools for working with multiple cells at once.
• Quickly navigate and manage watches using keyboard shortcuts that do not require the Watch Window.
• Improved Smart Fill functionality that recognizes common date inputs (e.g. 4Q10) and fills selected cells accordingly.
• Improved number format cycle performance and default number formats.
• Improved border theme behavior that more closely mimics the way Excel® natively applies borders to a selection of more than one cell.
• Improved performance for the Clean Up Defined Names tool.
• More icons and better action key identification/labeling in the ribbon.
• Better recognition of footnotes in cell text for the Footnote tool. Footnotes surrounded in square brackets or parenthesis are now recognized.
• Minor bug fixes in Smart Precedents/Dependents.

Version 2.4

2.4.9

• Now insert multiple rows/columns at once using Macabacus, just like native Excel® row/column insertion.
• Reorganized the Keyboard section of the Macabacus tab/menu. A list of Macabacus shortcuts can now be printed from the Hotkey Manager.
• Disabled keys settings are now saved so that each time you open Excel® the keys you specify will automatically be disabled.
• Fixes bug in 64-bit version of Excel® 2010 that prevented Smart Precedents/Dependents dialogs from displaying properly.
• Fixes bug in Excel® 2010 that caused the Smart Precedents/Dependents dialogs' width/height to be computed incorrectly.

2.4.8

• Fixes bug in Excel® 2007/10 that caused errors when opening a workbook when Excel® is initially closed.
• Fixes bug that caused some custom number formats to export improperly when exporting Macabacus settings.
• Returns Sum Bar tool to Macabacus Lite, and fixes a related bug that caused an error when using Sum Bar's legacy shortcut keystroke.

2.4.7

• Adds Quick Save tool/shortcut that lets you save files quickly without recalculating, regardless of calculation settings.
• Adds Check For Dependents tool/shortcut to check if any cells in a selected range are used in the calculation of other cells. A useful tool to prevent inadvertent deletion of precedent cells.

2.4.6

• Lets users specify a default error message/value when using Check for Errors on cell formulas, or be prompted for an error message/value.
• Adds new tool and shortcut to reposition cell comments and adjust their sizes to fit comments.
• Improves performance of the Paintbrush tool, which is now featured more prominently in Excel® 2007.
• Improves speed when saving Macabacus settings in the Settings and Hotkey Manager dialogs.
• Fixed Smart Precedents/Dependents bug that displayed an error message when attempting to open other add-ins files on some computers.
• Fixed Smart Precedents bugs related to formula arrays and defined names.

2.4.5

• Improved behavior for applying individual cell borders when more than one cell is selected. Behavior now mimics native Excel® border behavior.
• Increase/Decrease Decimals no longer changes the number format of cells when more than one cell is selected and selected cells have different number formats.
• Fixed bug in Footnote tool.

2.4.4

• The Trace Precedents/Dependents dialog now remembers its previous location, giving you greater control over its positioning.
• The Trace Precedents/Dependents dialog now automatically adjusts position to prevent overlapping highlighted cells (Excel® 2007 only).
• The Hotkey Manager now includes a button that lets you conveniently give priority to Macabacus shortcuts when other conflicting shortcuts are indescriminately given priority over Macabacus shortcuts upon starting Excel®.

2.4.3

• Big improvements to the reliability of Border Cycle that fix issues with the cycle halting unexpectedly in some cases.
• When borders in a cycle are equal on all four sides, borders are now applied around the selected range rather than to individual cells within that range.
• Improves reliability of individual cell border shortcuts through better recognition/observation of adjacent cell borders.
• Now select any color as the Macabacus cell border color (as opposed to the 4 grayscale options available in previous versions).
• Fixes a bug that prevented saving customized shortcut keystrokes using the Hotkey Manager in Excel® 2003.

2.4.2

• Fixes bug that caused an error when adding a cell comment (Excel® 2007 only).
• Fixes anchoring of checkbox on Smart Precedents/Dependents dialog.

2.4.1

• Smart Dependents/Dependents now includes the ability to expand collapsed rows/columns to view hidden precedent/dependent cells.
• Smart Precedents/Dependents now automatically navigates to the first precedent/dependent cell, saving a keystroke.
• Smart Precedents now processes precedents for TRANSPOSE formulas.
• Back by popular demand, the ability to import previously exported settings is restored.
• Default number format cycles now include "@_)" in formats with parenthetical negatives to improve alignment.

2.4

• Macabacus Macros rebranded as Macabacus Lite in preparation for a full-featured version available soon. Several non-core, infrequently used features/tools have been removed.
• Fixes many Undo issues by cutting the AutoColor on Entry feature altogether. AutoColor on Entry will eventually become available in the full-featured version.
• Adds number alignment shortcut.
• Improves Trace Precedents algorithm to better handle defined names in formulas.
• Improves Blue-Black Toggle compatibility with a more diverse set of custom color palettes.
• Removes splash screen that interrupted startup of Excel for some users.
• Eliminates need to activate product.

Version 2.3

2.3.5

• Makes several improvements to the functionality and interface of Smart Dependents.
• Smart Precedents can now select entire rows/columns when audited formulas contain notation such as "=SUM($5:$6)" and "=SUM($B:B)", for example.
• Adds new tool to delete all constant inputs values from worksheets. Potentially useful when starting fresh from a pre-populated model template.

2.3.4

• Adds ability for Smart Precedents to access hidden worksheets.
• Greatly improves performance and utility of Smart Copy Right/Down.
• Fixes potentially long delay upon copying cells or performing other operations on large cell ranges.
• Fixes Smart Precedents bug that prevented proper operation when "!", "_", or "." appeared in precedent sheets' names.
• Fixes overflow error when deleting a large number of cells.

2.3.3

• Adds ability to export/import your Macabacus Macros user settings so that you can easily transfer your customizations between computers.
• Adds a cycle to Fill Color Cycle that removes the selected range's fill color once the end of the cycle is reached.
• Implements an improved Border Cycle that avoids the use of workbook styles and fixes a related Border Cycle customization bug.
• Fixes Smart Precedents bug that prevented navigation to cell ranges when traversing the audited formula.
• Fixes bug related to customization of General Number and Currency Cycles that caused the number of decimal places to grow upon cycling.
• Fixes bug that prevented the insertion/deletion of single cells.
• Fixes intermittent bug that caused Excel® to freeze upon cut/paste (Excel® 2003 only).

2.3.2

• Improves Smart Precedents user interface for easier differentiation among listed cell references.
• Fixes bug that prevented query table refreshes from an external data source.
• Fixes bug that prevented repeating Paste Special actions.

2.3.1

• Allows greater customization of number format cycles.
• Minimizes screen flicker when AutoColoring cells upon entry.
• Fixes bug that prevented row/column insertion using native Excel® controls.
• Improves Undo performance and increases the number of actions that can be undone.

2.3

• Restores Undo command for most actions (execution of macros typically disables Undo).
• New actions and settings for managing cell comments.
• Toggle cell references in formulas between absolute and relative.
• Updates Error Wrap to use IFERROR (Excel® 2007 only).
• Paintbrush now allows you to capture up to 5 different styles and apply them in a cycle.
• Allows Paste Formulas Exact/Transpose more than once.
• Fixes bugs in Smart Precedents, and makes Smart Precedents/Dependent dialogs resizable.
• Expands multiple and percent number format cycles.
• Improves overall reliability and performance.

Version 2.2

• Select colors for your cycle settings from your own custom color palette, or any other color.
• Customize your Macabacus shortcut keystrokes with the new Hot Key Manager.
• Fixes intermittent problem that prevented opening of files upon first attempt.

Version 2.1

• Excel® 2007 now kicks it old school with optional Excel® 2003 menus and toolbars (Excel® 2007 only).
• Improves performance of Smart Precedents with support for named ranges.
• Adds Save As, Sum Bar, and Wrap Text shortcuts, as well as shortcut keystrokes for existing workbook clean-up tools.

Version 2.0

• More than doubles the number of shortcuts and features found in version 1.4.
• Allows users to customize various Macabacus Macros settings.
• Adds dynamic AutoColoring of fonts upon data entry and additional AutoColor options.
• Adds Power User Setup tool that allows experienced users to quickly set up Excel® for optimal use.
• Greatly improves Smart Copy and Smart Precedents/Dependents behavior.
• Adds Paintbrush tool to facilitate the capture and reuse of cell formats.
• Improves overall performance and fixes several issues/bugs.
• Increases number of options in several number formatting cycles.
• Includes ready-to-print list of Macabacus Macros shortcuts.
• Adds Harvey Ball shapes.
• Changes several shortcut keystrokes to improve consistency with other macro solutions.