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

Release Notes

Macabacus

Version 8.8

8.8.16 (29 Sep 2017) NEW

  • [PowerPoint, Word] Improved behavior when updating linked tables better preserves existing table formatting with that option enabled
  • [Excel] Clean Cells now removes non-printable characters from cell text
  • [Excel, PowerPoint, Word] Minor improvements

8.8.15

  • [Excel] Improved navigated cell(s) highlighting behavior in Pro Precedents/Dependents
  • [Excel] Added Lock/Unlock Scroll Area tools for restricting worksheet visibility to a particular range
  • [PowerPoint, Excel] Exporting cells as a chart no longer fails in certain scenarios and is slightly faster in Office 2016/2013
  • [PowerPoint] Fixed inability to update charts linked to cells in PowerPoint 2010/2007, only

8.8.14

  • [Excel] Added NavAid tool that shades rows and columns intersecting the selected range for improved navigation visibility
  • [Excel] Pro Precedents no longer freezes Excel when tracing precedents of a formula in a merged cell
  • [PowerPoint] Fixed bug that caused tombstone metadata to be lost when importing settings
  • [PowerPoint] Minor tombstone big fixes

8.8.13

  • [Excel, PowerPoint, Word] Linking and shared libraries now support file sharing services like Dropbox and OneDrive
  • [PowerPoint, Word] Fixed bug that could point chart links to a chart in the wrong workbook when the source workbook is closed
  • [PowerPoint] Introduced tools for adding and removing footnotes on a slide and updating the footnote order sequentially
  • [PowerPoint] Added Swap Text tool for swapping text between two shapes
  • [PowerPoint] Tombstones are now inserted from the library as shapes rather than images to fix graphics quality issues
  • [PowerPoint] Fixed inability to add new fields in the Tombstone Fields dialog

8.8.12

  • [PowerPoint] Fixed a font highlighting bug in Format Painter
  • [Excel] Fixed an incorrect error message shown when selecting the data range for a football field Quick Chart
  • [Excel] Fixed a bug that could lead to unexpected results with number formats and custom styles
  • [Excel, PowerPoint, Word] Removed support for legacy activation codes

8.8.11

  • [PowerPoint] Fixed inline text linking (beta) within placeholders
  • [Excel] Growth Arrow improvements and bug fixes
  • [Word] Added PDF to Folder tool for generating PDFs of a document with and without markup simultaneously
  • [Excel] Added workaround for Excel bug that could cause PDFs generated with Macabacus to not obey print areas
  • [Excel, PowerPoint, Word] User authentication and ribbon changes to support PowerPoint tools as a standalone product
  • [Excel, PowerPoint, Word] Minor updates

8.8.10

  • [PowerPoint, Word] Charts inserted from a Macabacus library now use source formatting by default
  • [PowerPoint, Word] Fixed chart size errors in charts exported from Excel as charts in some cases
  • [Excel] Improved support for chart data structured as a table in the Stacked Column Totals and Growth Arrow tools
  • [Excel] Recolor Series now recolors data points in pie charts rather than series
  • [Excel] Chart plot area sizing / positioning tools now use dimensions / positions that more intuitively exclude axes

8.8.9

  • [Excel] Added new Activate Sheet tool
  • [PowerPoint] Fixed error upon accessing MasterShapes and Styles menu when shape names include ampersands
  • [PowerPoint] Fixed New Presentation bug that could improperly order slides / sections in some cases

8.8.8

  • [Excel] Added new Inside Border Cycle tool
  • [Excel] Improved removal of corrupt styles in Style Scrubber
  • [Excel] Fixed error when creating butterfly Quick Charts with the data label position option set to "None"
  • [PowerPoint] Minor MasterShapes updates

8.8.7

  • [Word] Fixed inability to refresh Excel links caused by a bug introduced in v8.8.5

8.8.6

  • [Excel, PowerPoint, Word] Fixed offline mode problems introduced in v8.8.2
  • [PowerPoint, Word] Macabacus no longer automatically relinks to a file with a date / time last modified older than that of the original source file

8.8.5

  • [PowerPoint, Word] New progress bar shows percent completion when updating links
  • [Excel] Fixed incorrect chart dimensions shown and/or applied when using some chart resizing tools
  • [Excel] Improved how Pro Precedents handles evaluation of INDIRECT functions with Evaluate Functions & Groups enabled
  • [PowerPoint] Fixed link update error when links being updated include certain text links
  • [Excel, PowerPoint, Word] Fixed additional dialog / pane scaling issues on Ultra-High Definition (UHD) and 4k displays
  • [Excel, PowerPoint, Word] Fixed inability to select a white palette color in the Common Settings dialog in some cases

8.8.4

  • [Excel, PowerPoint, Word] Fixed additional dialog / pane scaling issues on Ultra-High Definition (UHD) and 4k displays
  • [Excel] Move Data Labels now works with series whose data points omit labels (e.g., a line chart where only the last data point is labeled)

8.8.3

  • [Word] Improvements to chart linking reliability
  • [Word 2010] Text links included within a broader text selection can now be updated
  • [PowerPoint] Inline text links (beta) no longer use hyperlinks
  • [Excel, PowerPoint, Word] Minor linking-related improvements and bug fixes
  • [Excel] Fixed rounding problem that may occur when generating PDFs
  • [Excel] Minor Pro Precedents bug fixes related to formula highlighting and evaluation of INDIRECT functions
  • [PowerPoint] Removed ability to link between PowerPoint shapes
  • [Excel, PowerPoint, Word] Other minor bug fixes and updates

8.8.2

  • [PowerPoint 2016] Implemented workaround for a Microsoft bug that produced an "Invalid request..." error when updating some links
  • [PowerPoint 2016] Implemented workaround for a Microsoft bug that unexpectedly closed the customization balloon when modifying TurboShapes
  • [Excel, PowerPoint, Word] Users no longer see an error that authentication failed at Office application startup on PCs requiring FIPS-validated cryptographic algorithms (rare)

8.8.1

  • [Excel] Fixed Undo bugs introduced in v8.8.0
  • [Excel, PowerPoint, Word] Minor improvement to chart linking reliability
  • [Excel, PowerPoint, Word] Minor updates

8.8.0

  • [PowerPoint, Excel] Inline text linking between Excel and PowerPoint is now possible (beta)
  • [PowerPoint] Integrated section / subsection titles with MasterShapes
  • [PowerPoint] Fixed inability to share tombstone metadata through enterprise configuration
  • [PowerPoint] Fixed slide and chart large preview images from appearing in the Library pane after the pane is initially closed and reopened
  • [PowerPoint] Replace Fonts tool no longer fails in Slide Master view
  • [Excel] Magnitude Map improvements let you apply visualizations by row or column for better insights
  • [Excel] Y-axis Max Format now supports secondary chart axes and Yen currency format
  • [Excel] Added additional chart Y-axis number formatting options
  • [Excel] Creating Quick Charts no longer fails when "unusual" charts (e.g., candlestick stock charts) are set as the default chart template
  • [Excel] Added a prompt to prevent inadvertently deleting all rows or columns on a worksheet when using Delete Row/Column tools
  • [Excel] Added shortcuts to toggle the Evaluate Functions & Groups and Highlight Navigated Cells options in the Pro Precedents / Dependents dialog
  • [Excel] Implemented workaround for an Excel 2016 bug that prevented charts from updating when charges were made to them using the Chart & Plot Size, Growth Arrow, and Move Data Labels dialogs until after those dialogs were closed
  • [Excel] Implemented workaround for an Excel 2013/2016 bug that caused Excel to crash upon canceling out of the Growth Arrow dialog when Windows animations are enabled
  • [Excel, PowerPoint, Word] Minor bug fixes and performance improvements

Version 8.7

8.7.1

  • [PowerPoint] Introduced styles for PowerPoint, which let you apply formatting styles similar to how you use styles in Word and Excel
  • [Excel] Added tools to remove blank rows and columns
  • [PowerPoint] Fixed bug introduced in v8.7.0 that prevented slides from loading in the New Content Slide dialog when the active template is set to the Macabacus sample template
  • [Excel, PowerPoint, Word] Fixed bug related to shared library caching settings introduced in v8.7.0

8.7.0

  • [PowerPoint] Introduced MasterShapes, which are shapes defined in your template's slide master that can be inserted from a menu in the ribbon
  • [PowerPoint] Integrated Copy/Apply Shape Properties buttons removed in v8.6.7 with the new Format Painter, restoring the ability to apply shape properties from the QAT
  • [PowerPoint] Improved behavior of shape alignment tools when a single shape is selected
  • [Excel] Fixed several bugs affecting systems with the Windows decimal symbol set to comma. Affects Growth Arrow, Row Height Cycle, Column Width Cycle, Font Size Cycle, and other tools
  • [Excel] Improved support for alternate row shading in filtered data
  • [Excel] Name Scrubber no longer considers native names (e.g., Print_Areas) "unused"; Name Scrubber filtering bug fixes

Version 8.6

8.6.7

  • [PowerPoint] Added new Format Painter tool that replaces the Copy / Apply Shape Properties tools
  • [PowerPoint] Speed improvements at start-up and when opening or creating new presentations
  • [PowerPoint] Minor Manage Links dialog updates
  • [PowerPoint] Minor Send to End updates
  • [Excel, PowerPoint, Word] Option to always used cached library content is now a shareable setting
  • [Excel, PowerPoint, Word] Other minor updates

8.6.6

  • [PowerPoint] Table of contents slides are now optional for both flysheet styles Agenda and Topic
  • [PowerPoint] Table of contents will automatically populate with slide titles in presentations with fewer than two sections
  • [PowerPoint] Minor agenda bug fixes
  • [PowerPoint] Select Match improvements related to grouped shapes
  • [Excel] Added new Footnote Cycle tool to append footnotes to cell contents using number formats
  • [Excel] Comment Formulas now comments numeric inputs in addition to formulas, and was renamed Comment Cells

8.6.5

  • [Excel] Added new Add Scenarios tool that creates input drivers (e.g., growth rates) for multiple scenarios in your projections
  • [Excel 2013, 2016] Macabacus now loads faster when starting Excel. As a consequence, Explorer, Tab Browser, and Shortcut Manager panes no longer load automatically at start-up if open when Excel was last closed
  • [Excel, PowerPoint, Word] Improved remote library caching performance to address potential issues with server latency in some environments
  • [Excel, PowerPoint, Word] Minor performance improvements, updates, and bug fixes

8.6.4

  • [PowerPoint] Fixed scaling of Proofing pane on Ultra-High Definition (UHD) and 4k displays
  • [Excel, PowerPoint] Fixed scaling of Explorer pane on Ultra-High Definition (UHD) and 4k displays
  • [PowerPoint] Fixed bug introduced in v8.6.3 that prevented publishing presentation templates to the library
  • [Excel] Resolved an issue where publishing certain charts could prevent content from loading in the Library pane in rare cases
  • [Excel, PowerPoint, Word] Minor bug fixes

8.6.3

  • [Excel, PowerPoint, Word] Fixed scaling of Library pane on Ultra-High Definition (UHD) and 4k displays
  • [Excel, PowerPoint, Word] Fixed bug that prevented content from appearing in the Library pane after publishing text on some PCs
  • [PowerPoint] Fixed bug introduced in v8.6.1 that prevented editing Excel links in the Edit Link dialog

8.6.2

  • [Excel, PowerPoint, Word] Fixed scaling of many dialogs on Ultra-High Definition (UHD) and 4k displays
  • [Word] Fixed bug that preventing linking when exporting merged cells from Excel to Word as tables with the option to recolor fonts enabled

8.6.1

  • [Excel, PowerPoint, Word] Macabacus libraries now support text content
  • [PowerPoint, Word] Manage Links dialog now shows who last updated or modified links
  • [Excel] Workaround for native Excel behavior (or bug) that unhides hidden rows in tables when exporting cells as a picture
  • [Excel] Macabacus now warns if Excel's 255 series limit will be exceeded when creating Marimekko charts and truncates data automatically if so
  • [Word] Macabacus no longer shows a particular error message when starting Word

8.6.0

  • [PowerPoint 2013, 2016] Introduced multi-state TurboShapes
  • [PowerPoint] Added Fix Bullets tool to conform bullet formatting to layouts and masters
  • [PowerPoint] Added Multiply Shape tool to replicate a shape in an arbitrary number of rows and columns
  • [PowerPoint] Added Align Over Table tool to align shapes over cells in a table object
  • [Excel, PowerPoint, Word] Fixed scrolling issues in the Library pane
  • [Excel, PowerPoint, Word] Other minor updates

Version 8.5

8.5.9

  • [Excel, PowerPoint, Word] Copying worksheets with linked ranges or charts will not interfere with link integrity as it previously did in some cases
  • [Excel] Sum Bar improvements
  • [PowerPoint] Publishing tombstones no longer fails when tombstone text contains "illegal" characters
  • [Excel, PowerPoint, Word] Other minor updates

8.5.8

  • [Excel] Stacked Column Totals is now less particular about the structure of chart data and fails under fewer scenarios
  • [Excel] Pro Precedents / Dependents no longer leave worksheet objects hidden if the audited cell's sheet is protected, and now warn that auditing cannot be performed on protected sheets
  • [Excel 2013, 2016] Pro Precedents / Dependents no longer show a "big red X" in Excel 2013 and 2016 running on Windows 7 when Windows visual styles are disabled
  • [Excel 2013, 2016] Opening a workbook no longer causes an "Object reference not set to an instance of an object" error to appear due to an Explorer pane bug affecting some users
  • [Excel] Minor improvements and bug fixes
  • [PowerPoint] Publishing shapes no longer fails when shape names or text contain "illegal" characters

8.5.7

  • [Excel] The formula shown in the Pro Precedents dialog now automatically scrolls to the highlighted portion of the formula as necessary
  • [Excel] Removed superfluous scrollbars in Pro Precedents/Dependents dialogs after expanding nodes
  • [Excel, PowerPoint, Word] Improved error logging when caching remote libraries

8.5.6

  • [Excel, PowerPoint, Word] Fixed bug introduced in v8.5.5 preventing caching of remote company and team libraries in Windows 7 and/or Office 2010, only

8.5.5

  • [Excel, PowerPoint, Word] Improvements to how Excel charts are linked in PowerPoint/Word; changing worksheet names no longer breaks chart links
  • [Excel, PowerPoint, Word] Remote library caching now updates only files and folders that have changed, reducing network load and improving speed

8.5.4

  • [Excel] Cosmetic Pro Precedents/Dependents improvements, particularly for Excel 2013 and 2016
  • [PowerPoint] Tombstones now import from the library as EMF, rather than PNG, images

8.5.3

  • [Excel, PowerPoint, Word] Added option to always used locally cached libraries to improve performance over slow networks
  • [Excel, PowerPoint, Word] Faster local caching of remote libraries in some cases
  • [Excel] Fixed Marimekko chart bug that could produce an "Invalid parameter" error and prevent the chart from being created
  • [Excel 2013, 2016] Fixed bug that could cause Excel to crash when Excel has no windows open initially and a new window is added/created

8.5.2

  • [PowerPoint] New Tombstone Data dialog that lets you view and edit all tombstone data at once
  • [PowerPoint] Tombstone functionality improvements and bug fixes
  • [Excel, PowerPoint, Word] Minor improvements and bug fixes

8.5.1

  • [PowerPoint] Added support for deal tombstones in Macabacus libraries to help you create tombstone slides ("creds" pages) quickly. You can filter and sort tombstones by closing date, deal size, or any other customizable field, then insert and arrange all desired tombstones neatly in a grid on your slide
  • [Excel 2013, 2016] Fixed an Explorer and Tab Browser panes bug that created duplicate panes upon clicking the "Enable Content" button in Excel's yellow message bar when working with macro-enabled workbooks. This fix also addresses a related bug that caused Excel to crash in some scenarios upon closing macro-enabled workbooks with the Explorer or Tab Browser pane visible
  • [Excel, PowerPoint, Word] Other minor bug fixes and improvements

8.5.0

  • [Excel, PowerPoint, Word] Library panes received a major upgrade with improved UI/UX, better performance/responsiveness, and various bug fixes related to searching and filtering library content

Version 8.4

8.4.4

  • [Excel, PowerPoint, Word] The active color palette selection is no longer overriden by shared settings
  • [PowerPoint] Fixed bug that could prevent certain slides from appearing in the Library pane
  • [PowerPoint] Minor improvement to checkbox behavior in the New Content Slide dialog

8.4.3

  • [Excel, PowerPoint, Word] Added option to compress (zip) PDFs and Office documents sent by email
  • [PowerPoint] Added PDF to Folder tool to save selected slides to the presentation's folder as a PDF
  • [Excel] Increase/Decrease Decimals now formats blank cells, too
  • [Excel] Bug fixes in New/Edit Style dialog related to style previews and pasting number formats
  • [Excel, PowerPoint] Other minor updates

8.4.2

  • [PowerPoint] Agenda automation now supports up to 50 section/subsection numbers/letters (previously 26)
  • [PowerPoint] Minor agenda improvements and bug fixes
  • [PowerPoint] Reorganized some ribbon buttons/menus for improved functional grouping
  • [Excel] Stacked Column Totals tool better supports non-contiguous chart data
  • [Excel, PowerPoint, Word] Other minor updates

8.4.1

  • [Excel] Improved support for non-English Excel and other non-English Windows settings in the Pro Precedents dialog when the Evaluate Functions & Groups option is enabled. This addresses a bug introduced in v8.2.4
  • [Excel] Added preview images for charts and other shapes to the Explorer Pane
  • [Excel] Explorer Pane no longer freezes when working with workbooks containing thousands of range names
  • [Excel, PowerPoint] Other minor updates

8.4.0

  • [PowerPoint, Word] Added new tool for redacting (i.e., blacking out) sensitive text
  • [PowerPoint] Added new Send to End tool for quickly moving slides to the end of a presentation
  • [PowerPoint] Added new Autofit Toggle tool to toggle between PowerPoint's "Do not Autofit" and "Resize shape to fit text" text box settings
  • [PowerPoint] Added new Split Text tool for splitting paragraphs into separate text boxes
  • [PowerPoint] Added new Replace Fonts tool to replace fonts throughout a presentation
  • [Excel] Added ability to memorize and apply plot area positions within charts and to apply memorized chart/plot size/position to multiple selected charts
  • [Excel] Fixed a bug that prevented multiple charts on a worksheet from appearing under that worksheet's node in Explorer Pane
  • [Excel] General performance improvements related to Undo/Redo
  • [Excel, PowerPoint, Word] Other minor performance improvements and ribbon updates

Version 8.3

8.3.1

  • [Excel, PowerPoint, Word] Minor stability improvements, bug fixes, and other updates

8.3.0

  • [PowerPoint, Word] Streamlined linking operations (Update Link and View Source) with automatic detection of source ranges/charts in open workbooks and transparent re-linking that better support a wider range of workflows and reduce reliance on absolute file paths
  • [PowerPoint, Word] Added ability to update all links in a presentation or document directly from the ribbon
  • [PowerPoint] Fixed a bug that closed the Manage Links dialog after updating links to shapes and slides in other presentations
  • [Excel] Pro Dependents now navigates to chart sheets whose chart data is sourced from the audited cell
  • [Excel] Fixed a publishing bug that could cause the Library pane to show the wrong preview image for charts in some cases
  • [Excel] Fixed a problem with importing default colors from shared settings published with an older version of Macabacus that did not include a default fill color used by the Alternate Row/Column Shading tool
  • [Excel] Addressed a Pro Precedents/Dependents conflict with the Workshare add-in's use of keyboard hooking
  • [Excel, PowerPoint, Word] Minor enhancements and bug fixes

Version 8.2

8.2.4

  • [Excel] Improved support for non-English languages and regional system settings, affecting multiple tools
  • [Excel] Added new tool for alternately shading odd/even rows/columns
  • [Excel, PowerPoint, Word] Improved content loading speed in Library panes in some cases
  • [Excel, PowerPoint, Word] General performance improvements and minor bug fixes

8.2.3

  • [PowerPoint] Added new Insert Text Box, Merge Text, and Ungroup Table tools
  • [Excel] Added ability to right-align cell content and italicize percentages when applying number format cycles
  • [Excel] Summary Statistics settings can be customized via a new dialog each time you use the tool
  • [PowerPoint] Fixed bug that inserted the same slide multiple times when inserting multiple slides from the Library pane at once
  • [PowerPoint] Inserting symbols into table cells is now possible
  • [Excel, PowerPoint] Minor updates and bug fixes

8.2.2

  • [Excel] Improved support for large Windows system font sizes (>100%, > 96 dpi)
  • [Excel] Fixed Quick Chart errors regarding conversion from string to type 'Double'
  • [PowerPoint] Slide Numbers dialog improvements; toggling slide number visibility no longer prevents slide numbers from updating automatically
  • [PowerPoint, Word] Fixed error when checking integrity of chart links with the Verify Link button in the Manage Links dialog
  • [Excel, PowerPoint, Word] Minor updates

8.2.1

  • [Excel] Improved Pro Precedents/Dependents dialog placement in multi-screen environments
  • [Excel] Paste Duplicate no longer pastes into charts when this operation is performed on worksheets containing charts
  • [Excel, PowerPoint, Word] Minor updates and bug fixes

8.2.0

  • [Excel] Performance and stability improvements for Tab Browser and Explorer panes, including faster loading (Excel 2013 and 2016, only)
  • [Excel, PowerPoint] Explorer pane interface improvements (Office 2013 and 2016, mostly)
  • [Excel] Pro Precedents/Dependents now leaves the previously hidden active sheet open as expected when closing the dialog, rather than always hiding it
  • [Excel] Case Cycle behaves more intuitively and no longer replaces formulas with text and preserves existing number formats
  • [Excel, PowerPoint, Word] Fixed Cache Now button disabled in Library Manager when unmapped UNC path is specified for shared library folders
  • [Excel] Removed temporary workaround for Excel 2016 bug that Microsoft recently fixed, restoring AutoColor on Entry for Excel 2016 users

Version 8.1

8.1.6

  • [Excel] Fixed bug that might cause error messages when showing custom styles as image galleries for some users

8.1.5

  • [Excel] Fixed bug affecting fill colors in custom styles on systems using commas as decimal separators

8.1.4

  • [Excel 2010, 2007] Fixed bug that could prevent custom styles from appearing under the Format menu

8.1.3

  • [Excel] Fixed bug that converted certain characters to "???" in number formats when settings were imported from the cloud
  • [Excel, PowerPoint, Word] Minor updates

8.1.2

  • [PowerPoint, Word] Now you can perform find/replace operations on source file paths for all links in a presentations/documents, or all presentations/documents in a folder (useful when you have renamed or moved a folder)
  • [PowerPoint] Emailing selected slides is now faster, particularly when the original presentation's file size is very large
  • [PowerPoint] Publishing slides to a library is now faster, particularly when the file size of the presentation being published is very large

8.1.1

  • [Excel] Added new Stack Charts and Save Chart as Picture tools
  • [Excel] Deconflicted default Apply Paintbrush shortcut with native Paste Special shortcut
  • [Excel] Removed keyboard shortcut to toggle visibility of the Explorer pane
  • [PowerPoint] Fixed bug that left the Proof menu disabled after closing all presentations and opening a new one
  • [Excel, PowerPoint] Minor ribbon updates

8.1.0

  • [Excel] Fixed bugs related to scrolling to charts and shapes in Explorer pane
  • [Excel] Fixed bug related to scrolling to search results in Super Find pane
  • [Excel] Pro Dependents now shows range names referencing the audited cell
  • [Excel] Replaced native Unhide dialog for unhiding sheets with an improved version that lets you unhide multiple sheets at once, including "buried" sheets
  • [Excel] Implemented temporary workaround for Excel 2016 bug that undoes the last change when saving and Macabacus Undo is enabled

Version 8.0

8.0.5

  • [Excel] Fixed bug introduced in v8.0.4 that prevented scrolling when navigating precedents/dependents
  • [Excel] Pro Dependents now shows charts whose series reference the audited cell
  • [Excel, PowerPoint, Word] Fixed bug preventing View Source from scrolling to a linked chart properly
  • [Excel] Removed error messages shown when creating new custom styles that have borders
  • [Excel] Minor Application Settings dialog interface improvements

8.0.4

  • [Excel] Fixed Quick Charts bug preventing users using a comma as the system decimal separator from creating charts
  • [Excel] Quick Charts now automatically detects system measurement units
  • [Excel] Quick Charts now prompts to unshare shared workbooks, rather than failing with an error
  • [Excel] Pro Precedents now finds precedents on hidden worksheets
  • [Excel] Pro Precedents no longer highlights navigated ranges (if enabled) that contain multiple fill colors, since Macabacus cannot reliably return such ranges to their original fill colors after navigation
  • [Excel] Center Cycle and Horizontal Cycle now prompt to unshare shared workbooks before unmerging cells, if desired, rather than failing with an error
  • [PowerPoint, Word] Fixed bug that cleared the list of linked shapes in Link Wizard after canceling an edit links operation
  • [PowerPoint, Word] Renamed the Link Wizard dialog to Manage Links (since it is not really a wizard)
  • [Excel, PowerPoint, Word] Minor updates

8.0.3

  • [Excel] Fixed errors when creating Quick Charts and the default custom chart template, if specified, is missing required chart elements

8.0.2

  • [Excel] You can now edit formulas "live" in the Pro Dependents dialog
  • [Excel] Pro Precedents/Dedpendents dialogs no longer navigate to the first precedent/dependent automatically upon opening
  • [Excel] Fixed bug preventing users who upgraded from specific versions of Macabacus from accessing new charting tools

8.0.1

  • [Excel] Pro Precedents can now handle fully qualified table references within the same workbook
  • [Excel] Now insert charts from the library using either source or destination formatting
  • [Excel] Publishing of charts to the library is easier, with fewer restrictions on what can be published
  • [Excel, PowerPoint, Word] Column sorting arrows are now hidden in structured Excel tables exported to PowerPoint and Word as pictures
  • [PowerPoint] Fixed height of Tab Browser tabs in Office 2016

8.0.0

  • [Excel] Major overhaul of charting tools that adds new tools for creating waterfall, football field, butterfly, Marimekko, and other charts
  • [Excel] New Growth Arrow tool to add CAGR and other growth rate arrows to column charts that update when chart data changes
  • [Excel] Move chart data labels precisely and easily with the new Move Data Labels tool
  • [Excel] Label Last Point improvements, including the ability to set label text to the data point value or its series name
  • [PowerPoint] Added ability to insert slides using destination formatting, which can avoid extraneous slide masters
  • [Excel] Fixed height of Tab Browser tabs in Office 2016
  • [Excel, PowerPoint, Word] Minor bug fixes and other updates

New Versioning Convention

Macabacus adopted a simpler versioning convention in v8.0, replacing separate version numbers for individual Office applications with a single version number. The following releases use the legacy (pre-v8.0) versioning convention.

Macabacus
for Excel

Version 7.2

7.2.7

  • Pro Precedents/Dependents dialogs now move as needed to avoid overlapping selected cells.
  • Minor bug fixes and ribbon updates.

7.2.6

  • Additional authentication improvements.
  • Now import Macabacus settings saved to the cloud.

7.2.5

  • New, simpler software activation method and related authentication improvements.
  • Drag-and-drop content from the Library Pane into your workbooks.
  • Specify an internal email address for Macabacus support inquiries.

7.2.4

  • Sample library now installs with Google material icons.
  • Macabacus settings can be uploaded automatically to the cloud and downloaded in Admin Console.

7.2.3

  • Name Scrubber performance improvements.
  • Paste Links no longer pastes links to empty cells.
  • Updated library controls in ribbon.
  • Minor bug fixes and updates.

7.2.2

  • Added option to highlight navigated cells in Pro Precedents/Dependents for improved visibility.

7.2.1

  • Eliminated Pro Precedents/Dependents navigation lag in some cases.
  • Fixed Discuss pane bug that prevented adding files from paths containing apostrophes.
  • Reliability improvements when exporting cells/charts as pictures.

7.2.0

  • Improved Formula Flow algorithm shows formulaic inconsistencies more reliably.
  • Formula Flow visualizations update automatically when changes are made to visualized cells.
  • Improvements to Functional Map visualization performance.
  • Added ability to find formulas referencing blank cells using Super Find.
  • Added additional tools to the charts context menu in Explorer.
  • Uniform Range tool renamed to Uniformulas.

Version 7.1

7.1.9

  • Beta release of new Discuss tool (Excel 2013 and 2016, only).
  • Improved support for Office applications running on terminal servers (Macabacus now ignores multiple instances of Office apps when terminal servers are detected and allows export operations to proceed).

7.1.8

  • Fixed bug that slowed Flatten tool considerably with large selections.
  • Implemented workaround for Microsoft bug causing number format and custom style previews to sometimes fail in the Application Settings dialog.
  • Improved activity reporting for formatting cycles.
  • Sign In/Out and Activate buttons are now grouped in a new menu on the ribbon.

7.1.7

  • Added new functions to Evaluate Functions and Simplify Formula tools.
  • Addressed issue with some third party UDFs showing formula errors in exported pictures and other shapes.
  • Minor ribbon update.

7.1.6

  • Added new Copy Path to workbook tool.
  • Improved handling of shared workbooks.
  • Minor stability improvements, bug fixes, and other updates.

7.1.5

  • Fixed Prepare to Share bug preventing collapse of all grouped rows/columns.

7.1.4

  • Added Prepare to Share option to collapse all grouped rows and columns.
  • Fixed inability to paste in the Application Settings dialog in some circumstances.
  • Improved Protected View operation.
  • Improved error handling and messaging.
  • Added ability to hide tools in beta testing.
  • Minor ribbon and other interface updates.

7.1.3

  • Minor updates.

7.1.2

  • Fixed bug that could cause Shortcut Manager to appear blank after updating from certain versions.

7.1.1

  • Shortcut settings can now be shared.
  • Consolidation of all settings into a single XML file, eliminating separate shortcut setting files.
  • Improved recognition of network drives for library caching purposes.
  • Minor updates.

7.1.0

  • Remote (network) libraries can now be cached locally and automatically at a customizable frequency.
  • Library pane loads large quantities of shapes, images, etc. much faster.
  • New keyboard shortcuts for Pro Precedents / Dependents allow you to adjust the size of the dialog.
  • Minor updates and bug fixes.

Version 7.0

7.0.1

  • Fix bug causing customized Custom Style Cycle names to appear incorrectly in Hotkey Manager.

7.0.0

  • Simplified customization of formatting cycles. See the Update Notes in the manual related to this release for more information.
  • New Application Settings dialog reflects simplified customization options.
  • Improved Clean Cells, AutoColor, and Pro Precedents performance in some cases.
  • Added ability to export cells and charts to a single cell in a Word table.
  • Library manifests now use relative paths to support library portability and future functionality.
  • Minor updates.

Version 6.14

6.14.0

  • Added new tool for recoloring series in a chart to customizable colors.
  • Font colors recolored when exporting cells and creating PDFs can now be specified separately, and are no longer based on AutoColor colors.
  • Improved Application Settings dialog with more intuitive layout and easier color configuration.
  • Eliminated multiple logout notifications.
  • Minor bug fixes and ribbon updates.

Version 6.13

6.13.1

  • Updated manual is now included as a PDF.
  • Restored previously removed tools for resizing cells to Standard Sizes or PowerPoint/Word selections.
  • Minor ribbon updates.

6.13.0

  • Added Simplify Formula tool and associated shortcut to make complex formulas easier to understand and audit.
  • Added tool to evaluate INDEX(MATCH) functions in formulas.
  • Pro Precedents now evaluates VLOOKUP and HLOOKUP functions in formulas as cell references when possible, and navigates accordingly.
  • Fixed Pro Precedents bugs when Evaluate Functions & Groups is enabled and precedent worksheet names contain parentheses.
  • Ribbon update to reflect above changes.

Version 6.12

6.12.10

  • Ribbon palettes now support fewer than 56 colors.

6.12.9

  • Fixed Pro Precedents bug that displayed only one of two inputs when auditing a TABLE function.
  • Fixed Bury Hidden Sheets bug.
  • Fixed chart size not updating immediately after applying memorized sizes in the Chart and Plot Size dialog.
  • Added context menu buttons for working with buried sheets and chart sizes (Excel 2010 and later).
  • Improved several tools' ability to work with protected worksheets.
  • Minor updates.

6.12.8

  • Behavioral improvements to several tools when working with protected worksheets.
  • Minor updates.

6.12.7

  • Minor improvements to implementation of borders in Macabacus styles.
  • Fixed bug that could produce invalid manifest XML when republishing items to the library.

6.12.6

  • Added ability to republish existing presentation, model, and document templates.
  • Charts exported to PowerPoint as charts now look identical to the source chart in more scenarios.
  • Minor updates.

6.12.5

  • Improved preservation of original theme colors when generating PDFs.
  • Speed / screen flicker improvements when duplicating workbooks and inserting models from the library.
  • Published model templates now belong to a document group for improved categorization.
  • Improved model template publishing, including batch publishing.
  • Rename library item descriptions in Library Manager.

6.12.4

  • Shift Decimal Left / Right improvements.
  • Minor Replicate Module updates.
  • More intuitive guide placement when inserting guides in some cases.
  • Flatten tool now works on selections that include multiple areas.
  • Other minor updates.

6.12.3

  • Major Replicate Module improvements and bug fixes.
  • Border style cycles now work with selections that include multiple areas.
  • Fixed bug that could insert incorrect values into cells when generating PDFs.
  • Workaround for Excel 2016 bug that prevented cell style previews from appearing in applicable dialogs.
  • Fixed bug preventing import of shared color palette settings published prior to v6.11.0.

6.12.2

  • Minor Fix Comment bug fixes.
  • Minor updates to export functionality.

6.12.1

  • Footnote Checker now inspects only visible cells for footnote sequencing.
  • Go to Min / Max tools now work with dates, are slightly faster over large ranges, and more reliably return the expected result.
  • Increase / Decrease Decimals works faster in certain scenarios.
  • Certain text formatting (e.g. superscript) is now preserved when generating PDFs.
  • Fixed bug that could prevent unhiding hidden columns when tracing precedents / dependents.
  • Minor updates.

6.12.0

  • Exporting linked pictures is now faster when the source range contains hidden cells and font recoloring is enabled.
  • Formula error warnings when exporting cells and generating PDFs now only appear if the errors are visible.
  • Improved Pro Precedents / Dependents navigation when precedent / dependent cells are hidden.
  • Label Last Point now supports X-Y scatter charts and features new ribbon controls for customization of appearance.
  • Fixed bug preventing display of Standard Sizes in the Common Settings dialog.
  • Fixed failure to warn about formula errors when generating PDFs in some cases.
  • Macabacus now prompts you to show objects in workbooks where they are hidden (rare) before inserting charts and other objects, avoiding errors.
  • Minor updates.

Version 6.11

6.11.0

  • Color palette controls in the ribbon can now be used to color chart elements.
  • Reorganized ribbon for more intuitive layout and better grouping of related functions.
  • Overhauled Style Scrubber (renamed from Batch Remove Styles) is much faster and better handles large workbooks with thousands of styles.
  • Added support for multiple color palettes.
  • Minor updates.

Version 6.10

6.10.0

  • Smoother navigation and minor performance improvements in Pro Precedents / Dependents dialogs.
  • Blue-Black Toggle now toggles between your AutoColor setting for inputs (typically blue) and your default font color (typically black), making the Blue-Black Toggle customizable.
  • PDF tools now skip selected sheets with no print areas, and avoid potential formula errors (e.g. #NAME!) when creating PDFs from workbooks containing third-party user-defined functions.
  • Minor updates.

Version 6.9

6.9.8

  • Fixed Paste Number Formats bug when pasting to multiple cells.
  • Removed Resize to Standard Size and Resize to Selection tools for cells, since column widths cannot be resized with the required precision due to Excel limitations.
  • Pulling shared settings now fails quietly, without an error message.

6.9.7

  • Added Prepare to Share option to zoom all worksheets to 100%.
  • Pro Precedents workarounds for Microsoft update KB3085502 bug affecting Excel 2013 build 4753.
  • Fixed Remove Guides bug.
  • Minor updates.

6.9.6

  • Added ability to attach a diagnostics report to an email to Macabacus Support.
  • Addressed bug in Microsoft update KB3085502 described in Microsoft community forums that can produce unexpected behavior.
  • Minor ribbon and other updates.

6.9.5

  • Fixed Common Settings dialog bug affecting Standard Sizes when the comma is used as the system decimal symbol.

6.9.4

  • Fixed bug introduced in v6.9.3 that could prevent exporting cells as a picture.

6.9.3

  • Workaround for an Excel 2013 bug that could cause Excel to navigate erratically after using Pro Precedents.
  • Minor operational improvements to Pro Precedents / Dependents and recording of Last Audited Cell.
  • Improved compatibility of several dialogs with larger system font sizes.

6.9.2

  • Performance improvements and bug fixes for several paste tools (e.g. Paste Exact).
  • Maximize View no longer shows potentially intrusive close button with ribbon hidden.
  • Performance enhancements and bug fixes.

6.9.1

  • Suppresses messages regarding range names when exporting cells as pictures as a result of changes made in v6.9.0.

6.9.0

  • Exporting cells to PowerPoint / Word as pictures is now faster and involves no window flicker.
  • When exporting cells as pictures, external data sourced with third-party functions no longer shows formula errors in the output in certain scenarios.
  • The remove borders when exporting option now only removes chart borders, not cell borders.
  • When exporting cells as a table, fonts are now recolored to the default font color rather than black.

Version 6.8

6.8.1

  • Now specify a default font color to be used instead of black for font recoloring purposes in certain operations (e.g. exporting cells).
  • New tool to check the sequence of footnotes in a selection or print areas.
  • Now search for footnotes with Advanced Find.
  • Sum Bar no longer fails when the default border color is not set to black.
  • Minor ribbon updates.

6.8.0

  • New footnote visibility toggle.
  • When applying footnotes, Macabacus now recognizes a wider range of footnote formats, including multiple footnotes.
  • Fixed bug that prevented publishing metafile images to the content library.
  • Minor updates.

Version 6.7

6.7.13

  • Fixed bug prompting for library path when publishing content and models even if library path was already set.
  • Fixed bug that could cause exporting cells as a picture to fail if single cells contain multiple font colors.
  • Minor updates.

6.7.12

  • Fixed bug that could report no errors when checking for errors using Prepare to Share.
  • Minor updates.

6.7.11

  • Fixed bug that placed charts exported to PowerPoint in the wrong z-order when a destination shape is pre-selected.
  • Minor updates.

6.7.10

  • Improved ability to connect to the Internet through a proxy server.
  • Macabacus now remembers Conform Size dialog settings.
  • Fixed Show in Folder bug that opened the wrong folder when file paths contained certain characters.
  • Minor updates.

6.7.9

  • Fixed bug that could cause exporting cells on a protected worksheet to fail.
  • Improved error handling.
  • Minor updates.

6.7.8

  • Support for Excel 2016.
  • Minor updates.

6.7.7

  • Pro Precedents / Dependents dialogs now include shortcuts for moving the dialog around the screen.
  • Minor performance improvements for a handful of tools.
  • Other minor updates.

6.7.6

  • Improved login experience, including fewer forced logouts, no login prompts while offline, and more.
  • Other minor updates.

6.7.5

  • Fixed bug that could prevent switching to Word upon exporting ranges / charts from Excel.

6.7.4

  • Improved Maximize View behavior, including new exit button when ribbon is completely hidden.
  • Fixed bug that could prevent shortcut settings from importing properly.
  • Fixed bug that could cause Excel to freeze when closing Application Settings dialog.
  • Minor library functionality updates.
  • Moved Move Sheet Left / Right buttons to Cells menu in the ribbon.

6.7.3

  • Pictures created when exporting large ranges are no longer truncated under certain conditions.
  • Publishing charts to the library now fails under fewer circumstances.
  • Removed "Unable to copy the Macabacus Chart Gallery" message that might appear when starting Excel.
  • New warning when trying to export with multiple Excel instances running.

6.7.2

  • Fixed bug in X-Y scatter plot labeling tool.
  • Fixed Clean Cells bug that prevented removal of sheet names with certain characters from formulas.
  • Minor ribbon and other interface updates.

6.7.1

  • New Chart Color Cycle tool (including shortcut) for cycling through customizable colors used in your charts.
  • Fixed Content Library pane bugs related to library/content filter toggles and text searching.
  • Fixed bug requiring Excel to be run as admin when opening workbooks in the team Model Library.

6.7.0

  • Overhauled the Chart Gallery, which is now part of the Content Library.
  • New Content Library pane lets you insert standardized charts, images, and other Office shapes into workbooks.
  • New Stacked Column Totals tool adds totals to the top of stacked column charts.
  • Ribbon updates and minor bug fixes.

Version 6.6

6.6.2

  • Pictures and embedded workbooks imported to PowerPoint / Word from Excel now show charts that overlap the exported cell range.

6.6.1

  • Added new Comment Formula tool for toggling on/off formula comments by adding/removing a leading apostrophe.
  • Ribbon improvements, including simplification of Export group and improved support for adding Macabacus controls to the QAT.
  • Hotkey Manager now shows descriptions of shortcuts in tooltips.

6.6.0

  • Added new Advanced Find tool for improved searching capability.
  • Added quartile functions to Summary Statistics tool.
  • Other minor improvements.

Version 6.5

6.5.5

  • Now save shared settings in the cloud.
  • Fixed Quick Save Up bug that could save workbooks to the wrong folder.
  • Minor ribbon updates.

6.5.4

  • Pro Precedents / Dependents dialogs now have a smaller footprint and close automatically when switching to another application.
  • Minor bug fixes and ribbon interface updates.

6.5.3

  • Fixed bug that recolored white fonts black upon exporting to PowerPoint/Word in some cases.

6.5.2

  • Improved matching of original workbook colors when exporting cells as a picture in some cases.

6.5.1

  • Improved formatting of Excel charts exported to Word as charts.
  • Improved font recoloring in cell ranges exported as tables to PowerPoint/Word.
  • Edit Link dialog interface improvements.
  • Minor performance improvements.

6.5.0

  • When exporting cells to PowerPoint/Word, Macabacus now only recolors fonts black that have AutoColor font colors.
  • Fixed bug that prevented audited formula highlighting in the Pro Precedents dialog with Evaluate Functions & Groups disabled.
  • Fixed Increase/Decrease Decimals bug that may have produced unexpected results in geographies where commas are used as decimals.

Version 6.4

6.4.5

  • Added workaround for PowerPoint 2007 bug that caused cells exported as tables to appear in the wrong position on the slide.

6.4.4

  • Changes to shared code with no material impact on Excel add-in.

6.4.3

  • Fixed error reporting bugs.
  • Minor Library Manager interface changes.

6.4.2

  • Fixed bugs that produced unexpected results when certain errors were encountered using various tools.
  • Improved compatibility when importing settings from older versions of Macabacus.
  • Fixed bug that prevented adding image content to the library.
  • Minor ribbon fixes.

6.4.1

  • Fixed permission issue with the team library.

6.4.0

  • Major overhaul to Macabacus libraries that simplifies library management, improves performance, and lays the foundation for future functionality. Those upgrading from v1.x should be advised that the new library framework is not backward-compatible, meaning that you may need to rebuild previously created model libraries.
  • Introduced a third library; there are now personal, team, and company libraries.
  • Simplified enterprise configuration.
  • Fixed Disabled Keys bug.
  • Duplicate Workbook now does a better job of preserving original workbook colors.
  • Some auditing tools will now display objects (e.g. trace arrows) automatically if initially set to hidden.

Version 6.3

6.3.11

  • Fix bug affecting linking to workbooks in virtual folders and some network drives.

6.3.10

  • Bug fix affecting configuration of the shared model library.

6.3.9

  • Error logging and reporting bug fixes.
  • Macabacus will try another directory when saving shared libraries manifests to a temp directory for which the user is not properly permissioned.

6.3.8

  • Improved error logging and reporting.
  • Minor interface updates.

6.3.7

  • Software update notifications can be disabled and/or configured in Shared Settings.
  • Send usage statistics can be disabled and/or configured in Shared Settings.
  • Minor bug fixes.

6.3.6

  • Minor interface changes.

6.3.5

  • Fixed Pro Precedents bug in Excel 2010 that turned off workbook object visibility.
  • Fixed incorrect Sign In / Out button enabled state after sign-in.

6.3.4

  • Improved Batch Remove Styles interface and performance when processing a very large number of styles.

6.3.3

  • Addressed some login issues.

6.3.2

  • Reduced or eliminated trace arrow flicker when using Pro Predecedents / Dependents.
  • Pro Precedents / Dependents now work when Excel is set not to show objects (rare).

6.3.1

  • Fixed v6.3.0 Macabacus Redo bug that inserted an extra undo step before beginning to redo.
  • Fixed v6.3.0 bug affecting Tab Browser and Explorer and which may prevent the Macabacus tab from appearing upon startup.

6.3.0

  • You can now sign into Macabacus using your Macabacus.com login rather than activate using a code.
  • Fixed Macabacus Undo bug introduced in v5.0 that slowed down several native Excel operations.
  • Fixed bug that prevented changing the Macabacus tab accelerator key in Excel 2013.
  • Prevents duplicates of some dialogs from being opened.
  • Macabacus Undo now recolors fonts properly.
  • Macabacus no longer interferes with external data refreshes when AutoColor on Entry and Undo are enabled.

Version 6.2

6.2.0

  • Added Font Size Cycle to the built-in collection of Macabacus style cycles.
  • Added Remove Print Areas tool.
  • Hide Page Breaks now works on all selected worksheets, not just the active one.
  • Returning all worksheets to cell A1 now also scrolls to cell A1, rather than just selecting it.
  • Fixed bug that could crash Excel or disable Macabacus on start-up with Maximize View set to maximize the application window on start-up (Excel 2013, only).
  • Fixed bug that could freeze Excel when fixing a comment containing a long string without spaces, such as a URL.
  • Improved algorithm for sizing a comment to fit its contents.
  • Fixed bug that prevented adding a new Macabacus style based on a native style.

Version 6.1

6.1.0

  • Added Wrap Parentheses and Set Print Areas tools.
  • Fixed bug that reversed spell check changes with Macabacus Undo enabled.
  • Fixed bug introduced in v6.0.0 that could cause Fix Comments to freeze Excel in some cases.
  • Minor bug fixes and performance improvements.

Version 6.0

6.0.0

  • Performance improvements to several tools, including Shift Decimal Left / Right, Increase / Decrease Decimals, Pro Fill Right / Down, and Error Wrap.
  • Added tool to quickly populate the Macabacus palette based on fill colors of selected cells.
  • Increase / Decrease Font now computes the font size of each cell in a selection individually, rather than applying a single font size to the entire selection, to avoid unexpected font size changes.
  • Fixed bug in Fix Comment and Delete Comment tools that exited the operation upon encountering a chart sheet.
  • Duplicate Workbook now duplicates chart sheets, and re-buries sheets if originally buried (i.e. "very hidden").
  • Certain sheet navigation tools now navigate to chart sheets.
  • Clean Used Ranges now reports results of the operation when complete.
  • Fixed bug causing Clean Used Ranges to halt unexpectedly in some cases.

Version 5.0

5.0.4

  • Excel starts faster with Macabacus authentication now performed in the background.
  • Fixed bug that prevented Buy and Activate buttons from appearing until the trial expired.

5.0.3

  • Fix bug introduced in v5.0.2 affecting ability to continue pasting a copied range after the first paste with Macabacus Undo enabled.

5.0.2

  • Hidden ribbon controls unhide upon successful activation of the product following trial expiration.
  • Fix Undo/Redo bugs affecting some cut/paste operations.

5.0.1

  • More intelligent number formatting of Summary Statistics.
  • Improved Fill Color Cycle behavior.
  • Fixed bug with shortcuts for Custom Cycles 6 through 8.
  • Minor performance improvements.

5.0.0

  • Added new Summary Statistics tool that computes statistics (e.g. minimum, median) for a set of data (e.g. comps).
  • Added new Reverse Columns/Rows tool that reverses the order of selected columns/rows.
  • Macabacus loads faster when starting Excel.
  • Hotkey Manager loads faster.
  • Improved undo behavior when AutoColor on Entry is not enabled.
  • Added undo capability to font size and text wrap formatting changes.
  • Improved AutoColor speed in some instances.
  • Fixed Clean Used Ranges bug that deleted grouped/collapsed rows/columns in some instances.
  • Improved behavior when downloading latest version of Macabacus via the ribbon.

Version 4.3

4.3.1

  • Fixed bugs affecting Pro Precedents and some export operations in non-English versions of Office.

4.3.0

  • Performance/behavioral improvements and bug fixes for Pro Precedents and Pro Dependents.
  • Code clean-up and minor performance improvements.

Version 4.2

4.2.8

  • Settings now upgrade automatically, so you no longer need to back up and restore settings when upgrading Macabacus on the same computer.
  • Code clean-up and minor performance improvements.

4.2.7

  • Faster authentication and activation.
  • Fixed bug that prevented the Macabacus tab from being activated upon starting Excel 2013, only, with that option enabled.
  • Minor performance improvements and bug fixes.

4.2.6

  • Improved hardware fingerprinting during authentication at startup and activation may resolve errors in some cases.
  • Macabacus now warns when Macabacus Lite is installed upon starting Excel.
  • Minor interface updates.

4.2.5

  • Combined shared model, template, and content manifests into a single manifest.
  • Reconfigured Shared Settings dialog to include management of the shared libraries manifest, and renamed the dialog Enterprise Configuration.
  • Updated links and information displayed in the About dialog.
  • Minor interface changes.

4.2.4

  • Batch Remove Styles can now remove corrupt styles.
  • Help buttons now refer to specific pages in the online manual in some instances.
  • Changed the name of the workbook Template Library to Model Library to avoid confusion with Macabacus' Template Library for PowerPoint.

4.2.3

  • Improved Pro Precedents/Dependents dialog positioning better accommodates multiple screens.

4.2.2

  • Shared settings now load automatically upon installation if applicable.

4.2.1

  • Added support for new Move Sheet Left/Right shortcuts when restoring shortcut settings from pre-v4.2.0 versions.
  • Overhauled installer and new first-run actions eliminate the most common installation problems.
  • Back up and restoration of settings is no longer required after installing an update to Macabacus.

4.2.0

  • New shortcuts to move selected worksheets left/right.
  • Fixed bug affecting row/column unhide/ungroup operations.
  • Improved handling of buried (i.e. "very hidden") sheets in Macabacus Explorer.
  • Improved error reporting.

Version 4.1

4.1.14

  • Performance improvements and bug fixes for Paste Duplicate and Paste Insert.
  • Minor Macabacus Explorer interface changes.

4.1.13

  • Fixed tree navigation of chart sheets in Macabacus Explorer.
  • Code signing now uses SHA-2.

4.1.12

  • Improved Undo behavior in PowerPoint 2010 and 2013 after exporting from Excel.
  • Pro Precedents/Dependents can now handle single quotes in worksheet names.
  • Minor error handling improvements related to authentication and exporting from Excel.

4.1.11

  • When exporting Excel print areas to PowerPoint as pictures, new slides are now added at the selected insertion point and use the layout of the originally selected slide.
  • Improved error handling when Excel is in edit mode.
  • Minor bug fixes and performance improvements.

4.1.10

  • Fixed bug introduced in version 4.1.9 that prevented some Macabacus operations from working after exporting to PowerPoint.
  • Improved the Common Settings color palette interface.

4.1.9

  • User interface improvements.
  • Minor bug fixes and performance improvements.

4.1.8

  • Minor bug fixes and performance improvements.

4.1.7

  • Improved support for exporting charts on chart sheets.
  • Minor bug fixes related to exporting charts.

4.1.6

  • Fixed Prepare to Share bug affecting removal of charts.
  • Added tools to "bury" and "dig up" sheets in workbook.
  • Minor performance improvements and bug fixes.

4.1.5

  • Improved Quick CAGR dialog with bug fixes.
  • Fixed failure to recognize inline shapes when processing Word selections.
  • Minor bug fixes and ribbon improvements.

4.1.4

  • Created new Export group on the Macabacus tab for more direct access to all export tools.
  • Added new ways to export cells and charts from Excel to PowerPoint or Word.
  • Added ability to resize charts to a selected range of cells.
  • Minor bug fixes.

4.1.3

  • Various improvements to the performance and behavior of Paste Match.
  • Minor bug fixes.

4.1.2

  • Code efficiencies and minor performance improvements.

4.1.1

  • Split application-level and Office-level settings into separate dialogs to support Macabacus Suite, which moved some settings from the Customize dialog into the new Common Settings dialog, and reorganized the Settings menu on the ribbon.
  • Fixed minor bug when saving Standard Sizes.

4.1.0

  • Enterprise support for sharing certain Macabacus settings (e.g. color palette) across an organization and restricting end user ability to modify those settings locally.
  • Improved Template Library that supports sharing model templates across an organization and is pre-populated with Macabacus.com's most popular model templates.

Version 4.0

4.0.4

  • Code clean-up and minor bug fixes.

4.0.3

  • Receive notification in the ribbon when an update is available.
  • Code clean-up and minor performance improvements.

4.0.2

  • Fixed Last Audited Cell bug introduced in v4.0.0.

4.0.1

  • Paste Duplicate now warns when about to overwrite cells that could cause a #REF! error.
  • Improvements to Name Scrubber search feature.
  • Batch Remove Styles now removes only non-built-in (i.e. custom) Excel styles, and prompts to unshare shared workbooks from which styles cannot be removed.
  • Minor bug fixes.

4.0.0

  • Faster loading of Pro Precedents/Dependents dialogs.
  • Pro Precedents will now evaluate Excel functions and expressions in parentheses.
  • You can view nested precedent and dependent levels in a tree view in any supported version of Excel.
  • Legacy mode for Pro Precedents/Dependents is deprecated, as it is no longer required for some Office installations (particularly, Excel 2013).
  • The Excel 2013 single document interface no longer poses cross-workbook navigation challenges to Pro Precedents/Dependents.
  • Major overhaul of Name Scrubber, including improved interface and performance, faster processing, and new features.
  • More reliable Unapply Names tool.

Version 3.1

3.1.4

  • Improved error handling for Pro Precedents/Dependents when the audited workbook is protected.

3.1.3

  • Added Macabacus Undo to Pro Fill Right/Down.
  • Improved recognition of partial inputs for AutoColor and Functional Map tools.
  • Minor bug fixes.

3.1.2

  • Performance improvements and bug fixes for Clean Number Formats.
  • Performance improvements to Show All Precedents/Dependents.
  • Bug fixes.

3.1.1

  • Performance improvements to several row/column tools, particularly when operations involve large numbers of rows/columns.
  • Hotkey Manager now shows you which shortcut conflicts with the one you selected.
  • Hotkey Manager now allows you to restore default keystroke settings for individual shortcuts.
  • Fixed a bug that prevented Proper Hide from operating on columns to the right of Excel's UsedRange.
  • Minor bug fixes to Show All Precedents/Dependents and Hotkey Manager.

3.1.0

  • Apply Paintbrush produces more intuitive results and more closely emulates native Excel paste operations.
  • Fixed a Pro Precedents bug that froze Excel when auditing formulas with no precedents.
  • Fixed a bug affecting row/column insertion while in Copy mode.
  • Minor performance improvements and bug fixes.

Version 3.0

3.0.5

  • Fixed some problems with importing shortcut settings exported from v3.0.0 or older.
  • Fixed bug that prevented saving disabled shortcuts in Hotkey Manager.

3.0.4

  • Explorer and Tab Browser now ignore worksheet objects embedded in PowerPoint and Word files.

3.0.3

  • Palette settings are now accessed from a dedicated button on the Settings menu, rather than the Customize dialog.
  • Minor bug fixes, particularly relating to Favorites.

3.0.2

  • Fixed a bug that prevented some shortcuts from working properly.

3.0.1

  • Hotkey Manager now displays in a pane at the edge of the screen for easier reference while you work.
  • Improved support for non-English keyboards.
  • AutoTrace Precedents/Dependents now works on selections of up to 20 cells, rather than just the active cell.
  • AutoTrace Dependents no longer causes a computer beep when no dependents are found.

3.0.0

  • Major overhaul of Macabacus Explorer, including performance improvements, new functionality, and bug fixes.
  • Major overhaul of Tab Browser, including performance improvements, new functionality, and bug fixes.
  • Improved support for the Excel 2013 single document interface (SDI).
  • Pro Precedents/Dependents dialogs now remain right where you leave them on the screen the next time you use them.
  • Duplicate Workbook now preserves the color theme used in the original workbook, rather than applying the default Excel theme.
  • Reactivation no longer required if upgrading from v2.2.2 or later.
  • Other performance improvements and bug fixes.

Version 2.2

2.2.2

  • Reduced flicker in the audited formula in the legacy Pro Precedents dialog when navigating precedents.
  • Even more settings now persist across Excel sessions.
  • Minor performance improvements.

2.2.1

  • Further improved performance for Pro Precedents/Dependents; legacy trace dialog (default setting in Excel 2013, only) opens significantly faster.
  • Certain settings now persist across Excel sessions.

2.2.0

  • Improved performance and behavior for Pro Precedents/
    Dependents, including faster speed and reduced flickering.
  • Faster Unhide Row/Column and Ungroup Row/Column operations.
  • AutoColor on Entry better supports native Excel behavior when the Excel selection is set to move after pressing Enter.
  • Paste Insert no longer throws an error message when pasting cells after a Cut operation.
  • Charts can now be inserted from the Macabacus Chart Gallery when a chart sheet is initially selected in the destination workbook.
  • Other minor performance enhancements and bug fixes.

Version 2.1

2.1.5

  • More intuitive, thematic default number formatting cycles.
  • Added to Prepare to Share the ability to bury a hidden worksheet.
  • Minor performance improvements and bug fixes.

2.1.4

  • Added ability to email selected sheets, only, to the PDF / Email menu.
  • Macabacus checks for and warns about workbook links when attaching workbooks to emails.
  • Other minor enhancements.

2.1.3

  • Added ability to email workbook modified using Prepare to Share.
  • Added ability to email workbook from renamed PDF / Email menu.
  • Macabacus Pro no longer forces manual calculation mode upon opening Excel in some cases.

2.1.2

  • Renamed Clean Formulas tool to Clean Cells, which now also removes leading, trailing, and extra spaces from cell text.
  • Added to Prepare to Share the ability to clean cells.
  • Added ability to undo a Clean Cells operation (except when executed on the entire workbook from the Prepare to Share menu).
  • Updated Paste Match tool to support workbooks employing non-default Excel themes.

2.1.1

  • Macabacus no longer automatically rescales the vertical chart axis when exporting charts using Paste Match tools.
  • Fixed bug preventing display of template spreadsheets in the Template Browser when selected in Excel 2013.
  • Fixed bug that sometimes produced unexpected results when deleting hidden rows/columns using Prepare to Share tools.
  • Other minor bug fixes.

2.1.0

  • Enabled button on the Macabacus tab that links to Macabacus Pro's online manual.
  • Added menu to insert commonly used symbols more quickly than using the native Symbols dialog.
  • Added option to Prepare to Share (renamed from Prepare for Distribution) to return all sheets in a workbook to cell A1.
  • Reshuffled some items on the Ribbon to improve accessibility and updated some Ribbon icons in Macabacus Pro 2013.
  • Fixed bug affecting Go To Min/Max tools when used with some number formats.
  • Fixed bug causing Excel 2013 to freeze when using Maximize View with the both the hide Ribbon and minimize Ribbon options enabled.

Version 2.0

2.0.2

  • When Show All Precedents/Dependents takes a long time to display trace arrows, Macabacus will now periodically ask if you want to abort the operation. This prevents Excel from appearing to freeze when auditing some formulas.
  • Minor performance enhancements.

2.0.1

  • Added a new tool to clear Macabacus visualizations. You can still use the Undo shortcut or button to undo a visualization.
  • Edits to the color palette in the Customize dialog are now reflected immediately; you no longer need to reopen the dialog between editing the palette and making changes to color cycles.
  • Improved Undo support for fill color changes.

2.0.0

  • Macabacus tab renders faster when selected.
  • New authentication procedures. Version 2.0 is now required for activation.
  • Trials begin automatically upon first use, and registration is no longer required from within Excel.
  • PDF to Email and PDF to Folder tools no longer throw errors when there is nothing to print.
  • Fixed a bug that caused Excel® to freeze when Clean Up Used Ranges was run on a blank worksheet.

Version 1.0

1.0.7

  • For Windows 8 users who have experienced Excel crashing when using Pro Precedents/Dependents, we have added the ability to revert to our legacy trace dialog that will not crash Excel. This addresses a bug in some Windows 8 configurations, and is not an issue for older, more stable versions of Windows.

1.0.6

  • For Excel 2007, only, fixed popup alert when performing Increase/Decrease Decimals.

1.0.5

  • Added Undo for Increase/Decrease Decimals operations.

1.0.4

  • Worked around an Excel® deficiency that changes number formats of cells when a native decimal increase/decrease operation is performed on a selection of cells containing multiple number formats. Macabacus' Increase/Decrease Decimals tools now resolve this deficiency.

1.0.3

  • Fixed a Pro Precedents bug that prevented recognition of some cell references in some formulas.

1.0.2

  • Fixed a bug that prevented copying cells to another worksheet when Macabacus was set to automatically hide gridlines.
  • Fixed a bug that kicked Excel® out of copy/cut mode when AutoTrace Precedents/Dependents was enabled.
  • Updated installer to automatically remove older Macabacus Pro versions upon installation.

1.0.1

  • Fixed a bug that froze the Excel® window when AutoColor on Entry was enabled and the user inserted cells, but not an entire row/column.
  • Reduced worksheet flicker when AutoColor on Entry is enabled.

1.0.0

  • Faster Pro Precedents performance.
  • Added workbook optimization tool to delete multiple Excel® styles at once.
  • Added individual workbook preparation for distribution actions to the ribbon menu.
  • Coloring fonts black when preparing a workbook for distribution will no longer recolor white fonts.
  • Reopen tool now memorizes your calculation state in all cases.
  • Degrades to functionality found in Macabacus Lite after trial or subscription expiration, rather than becoming completely disabled.
  • Minor performance enhancements and bug fixes.

Version 0.3 (beta)

0.3.3

  • Removed trace arrow flicker when using AutoColor on Entry.

0.3.2

  • Fixed a Pro Dependents bug.

0.3.1

  • Added ability to specify the font case (e.g. upper, lower) in Macabacus styles.
  • Fixed problem with arrow keys occasionally becoming temporarily unresponsive after closing the Customize dialog.
  • Minor performance enhancements and bug fixes.

0.3.0

  • Added four new visualization tools that make auditing spreadsheets even easier.
  • Refreshed the Uniform Range tool for more intuitive functionality.
  • New Tab Browser with improved performance.
  • New installer that reduces installation problems.
  • Minor changes to the ribbon interface, including a separate Audit group.
  • Minor performance enhancements.

Version 0.2 (beta)

0.2.1

  • Improved scaling of Macabacus dialog fonts when Windows system font size is set to larger than default.
  • Focus no longer shifts to Macabacus Explorer when the Explorer is open and a new workbook is opened.
  • Flip Sign no longer fails unexpectedly when it encounters an array formula.

0.2.0

  • Overhauled the Pro Precedents/Dependents dialog to incorporate easier, tree-based navigation of nested precedents/dependents; adjustable split between formula textbox and precedents/dependents tree to facilitate viewing long formulas; memory of your last dialog dock position between sessions of Excel®, and other enhancements.
  • Export PDF of printable areas on selected sheets to either a new email or to a specified folder. This handy tool recolors fonts black and white and checks for formula errors upon export, just like Paste Match tools for exporting to PowerPoint® and Word®.
  • Updated installer to reflect Macabacus as a trusted publisher.

Version 0.1 (beta)

0.1.3

  • Added OFFSET to the list of Excel 2007® functions that can be evaluated.
  • Added Apply and Unapply options to the context menu for defined names in Macabacus Explorer.

0.1.2

  • Fixed a Paste Match bug that caused pasting to fail when a PowerPoint® shape contained within a placeholder was initially selected.
  • Fixed a Paste Match bug affecting Excel 2007® that caused pasting into PowerPoint® to fail when Macabacus was set to recolor fonts black.

0.1.1

  • Added Evaluate Function tool that replaces certain native Excel® functions with the cell references and/or values to which they evaluate. The existing Untranspose tool is now part of this toolset.
  • Minor Ribbon changes to accommodate the new tools.

0.1.0

  • Added Smart Print Area tool.
  • Added additional Prepare for Distribution options for workbooks. Prepare for Distribution settings are now saved after each use.
  • Fixed a bug in v0.0.16 that could cause Excel to crash with AutoColor on Entry enabled.
  • Added shortcut keystroke for Reopen tool.
  • Removed shortcut keystrokes for certain infrequently used utilities.
  • Minor performance enhancements.

Version 0.0 (beta)

0.0.16

  • Eliminated screen flicker when performing some operations on a large number of cells.
  • Fixed ribbon error at startup in Excel® 2007 when user interface errors are enabled (uncommon).

0.0.15

  • Improved error reporting for problems connecting to the Internet encountered during activation.

0.0.14

  • Synchronized contents of the "file" [context] menus on the Macabacus tab in the ribbon, in Macabacus Explorer, and in Tab Browser.

0.0.13

  • Added Quick Save Up tool for saving new versions of files.
  • Added shortcut keystrokes for all Quick Save tools.
  • Improved context menu in Tab Browser.
  • Minor performance enhancements.

0.0.12

  • Improved support for international decimal separators (e.g. commas).

0.0.11

  • Fixed a bug that prevented some shortcuts from working when Border None was disabled in the Hotkey Manager.
  • Fixed the display of shortcuts keystrokes for border cycles in the ribbon.
  • Improved behavior for Insert Row/Column.

0.0.10

  • Added Hide Page Breaks shortcut.
  • Optimized and fixed a minor bug in the ribbon.
  • Fixed a bug that prevented Maximize View from minimizing the ribbon in Excel® 2007.
  • Changed the default shortcut for Toggle Gridlines to avoid potential conflicts with tab keytips.

0.0.9

  • Added a "minimize ribbon" option to the Maximize Workspace settings to complement the existing "hide ribbon" option.
  • Fixed a bug preventing Cycle Fill from functioning predictably when white was included in the fill color cycle.

0.0.8

  • Performance improvements and fixed bugs for the Tab Browser.
  • Style capture dialog bug fixes.

0.0.7

  • Fixed disappearance of shortcut keystrokes from Ribbon mouseover tips.

0.0.6

  • Fixed bugs affecting import/export of shortcut keystrokes in the Hotkey Manager.

0.0.5

  • Fixed a bug affecting number formats when creating and editing styles.

0.0.4

  • Fixed a bug preventing shortcuts from working in some Windows/Excel configurations.
  • Included bootstrapper to install .NET Framework 4 Client Profile if missing prior to installing Macabacus Pro for Excel 2010.

0.0.3

  • Fixed a bug that required some users to activate Macabacus Pro after every Excel restart.

0.0.2

  • Fixed a bug that prevented some users from opening the Customize and several other dialogs.

Macabacus
for PowerPoint

Version 4.5

4.5.8

  • Fixed bug that caused slide stamps with ampersands to fail to display in the ribbon.
  • Fixed bug that caused table font recoloring to fail in some cases when initiated from the Macabacus palette in the ribbon.
  • Minor ribbon updates.

4.5.7

  • Additional authentication improvements.
  • Now import Macabacus settings saved to the cloud.

4.5.6

  • New, simpler software activation method and related authentication improvements.
  • Drag-and-drop content from the Library Pane into your presentations.
  • Specify an internal email address for Macabacus support inquiries.

4.5.5

  • Sample library now installs with Google material icons.
  • Macabacus settings can be uploaded automatically to the cloud and downloaded in Admin Console.

4.5.4

  • New grammar checks in proofing tools.
  • Clicking native buttons in the ribbon or content placeholders to insert pictures and charts can optionally open the library and display available pictures/charts.
  • Updated library controls in ribbon.
  • Minor bug fixes and updates.

4.5.3

  • Improved PDF quality, reducing pixelation of images on PDF'd slides.

4.5.2

  • Reliability improvements when importing cells/charts as pictures and updating linked pictures.

4.5.1

  • Added new Proofing checks (curved vs. straight apostrophes, square bracket text placeholders, global font family and font size counts, and multiple slide masters).
  • Reordered ribbon controls.

4.5.0

  • Major improvements to Proofing tools, including global presentation fixes, improved processing of charts and SmartArt, greater stability, bug fixes, and user interface updates.
  • Improved support for Office applications running on terminal servers (Macabacus now ignores multiple instances of Office apps when terminal servers are detected and allows import operations to proceed).
  • Improved Recolor dialog support for charts.

Version 4.4

4.4.5

  • Proofing pane behavior and UI improvements.
  • Sign In/Out and Activate buttons are now grouped in a new menu on the ribbon.

4.4.4

  • Fixed bug that could cause agenda-style flysheets to update improperly with Omit Double Fylsheets enabled.
  • Improved behavior for including shapes in and excluding shapes from the table of contents.
  • Addressed issue with some third party UDFs showing formula errors in imported pictures and other shapes.

4.4.3

  • Added new Copy Path to presentation tool.
  • Minor updates.

4.4.2

  • Improved Protected View operation.
  • Improved error handling and messaging.
  • Linking to workbooks that have never been saved (e.g., "Book1") is no longer possible.
  • Added ability to hide tools in beta testing.

4.4.1

  • Improved recognition of network drives for library caching purposes.
  • Minor updates.

4.4.0

  • Remote (network) libraries can now be cached locally and automatically at a customizable frequency.
  • Library pane loads large quantities of shapes, images, etc. much faster.
  • Added ability to filter links in Link Wizard.
  • Minor updates and bug fixes.

Version 4.3

4.3.5

  • Library manifests now use relative paths to support library portability and future functionality.
  • Minor updates.

4.3.4

  • Eliminated multiple logout notifications.
  • Fixed bug preventing PDF manual from opening.

4.3.3

  • Updated manual is now included as a PDF.
  • Apply Active Template now asks whether you want to replace existing Slide Masters if they are "preserved."
  • Minor updates.

4.3.2

  • Fixed error message upon starting PowerPoint 2007 introduced in v4.3.1.
  • Improved Harvey Ball sample shapes.
  • Ribbon palettes now support fewer than 56 colors.

4.3.1

  • Added ability to set the proofing language for the entire presentation.
  • Proofing tools now inspects charts, tables, and SmartArt in placeholders.
  • Recolor dialog now works with charts, tables, and SmartArt in placeholders, among other bug fixes.
  • Minor bug fixes and updates.

4.3.0

  • New Airplane Mode to redact logos for greater privacy when working in close proximity to others.
  • Create a new presentation containing a single content slide, or "rider," based on the active template.
  • Now add default sections to new presentations (PowerPoint 2010 and later).
  • Improved Undo behavior after inserting items (e.g. slides, images) from the library (PowerPoint 2010 and later).

Version 4.2

4.2.0

  • To simplify template configuration, slides are no longer required in Macabacus-enabled templates.
  • Bug fixes and improved interface and template validation in Template Wizard.
  • Breaking changes to configuration of Macabacus-enabled templates in PowerPoint 2007, only.
  • The "cover page" special layout / slide is now referred to as the "title page."
  • Fixed bug that could produce invalid manifest XML when republishing items to the library.
  • Minor updates.

Version 4.1

4.1.5

  • Added ability to republish existing presentation, model, and document templates.
  • Charts imported from Excel as charts now look identical to the source chart in more scenarios.
  • Minor updates.

4.1.4

  • Published presentation templates now belong to a document group for improved categorization.
  • Improved presentation template publishing, including batch publishing.
  • Rename library item descriptions in Library Manager.
  • Minor updates.

4.1.3

  • Fixed bug preventing import of shared color palette settings published prior to v4.0.5.

4.1.2

  • View Source can now recognize a workbook open in Excel as the link source if it has the same name, but different path, as the source workbook.
  • Improved link update behavior for linked tables and links to charts when the source range / chart is hidden.
  • Minor updates to linking functionality.

4.1.1

  • Macabacus no longer expands grouped / collapsed rows and columns when updating links.
  • Fixed bugs related to updating links to hidden cell ranges.
  • Fixed failure to unhide hidden columns in the source range when using View Source due to bug introduced in v4.1.0.
  • Minor updates.

4.1.0

  • Added tool to quickly recolor many shapes in a presentation at once.
  • Importing / updating linked pictures is now faster when the source range contains hidden cells and font recoloring is enabled.
  • Formula error warnings when importing cells / updating links now only appear if the errors are visible in the source range.
  • Improved identification of potentially newer versions of source files when updating links.
  • Improved View Source behavior when the source range is hidden.
  • Link Wizard now shows the correct source file path after updating links when you change the source file.
  • Macabacus now prompts to save changes as needed before reopening a presentation.
  • Fixed bug preventing display of Standard Sizes in the Common Settings dialog.
  • Fixed bug that prevented inserting slides from the library in PowerPoint 2007, only.
  • Fixed bug that prevented duplicating a presentation in PowerPoint 2007, only.
  • Fixed bug that could open multiple Excel windows when viewing a linked shape's source in rare cases.
  • Minor updates.

Version 4.0

4.0.5

  • Added support for multiple color palettes.
  • Minor updates.

4.0.4

  • Added tool to highlight all linked shapes and slides in a presentation.
  • Minor ribbon and other updates.

4.0.3

  • Improvements when publishing slides or otherwise "exporting" slides as pictures using native methods.
  • Pulling shared settings now fails quietly, without an error message.

4.0.2

  • Improved selection behavior for linked shapes in the Link Wizard dialog.
  • Restores PowerPoint window if initially minimized when exporting from Excel to PowerPoint.
  • Simplified the Import from Excel menu.
  • Fixed bug introduced in v4.0.0 that prevented publishing templates to the library.
  • Template Wizard may no longer considers templates valid if created before v3.2.1.
  • Minor updates.

4.0.1

  • Added ability to attach a diagnostics report to an email to Macabacus Support.
  • Enhanced functionality for shape alignment / sizing tools.
  • View Source now works when the source workbook's window is minimized.
  • Improved, more meaningful error messages when importing / updating linked shapes fails.
  • Minor ribbon and other updates.

4.0.0

  • Macabacus now accesses the the active template far less frequently, which improves performance when working with Macabacus-enabled templates (especially when the template resides on a shared network drive).
  • Tighter integration between Macabacus-enabled template and native PowerPoint functionality.
  • Improved automatic slide numbering and stamping when inserting slides based on Macabacus-enabled templates.
  • Inserting intentionally blank slides as needed now works when the presentation's flysheet style is set to Agenda.
  • Resolved issues that prevented the active template from closing once Macabacus is done working with it (especially important when the template is shared).
  • Fixed Common Settings dialog bug affecting Standard Sizes when the comma is used as the system decimal symbol.
  • Fixed Link Wizard bug causing information in some columns to be blank.

Version 3.5

3.5.4

  • Fixed bug introduced in v3.5.3 that could prevent importing cells as a picture.

3.5.3

  • New Content Slide dialog that now shows more detail in thumbnail preview images, loads thumbnails a bit faster, and uses layout names as descriptions.
  • Linked pictures are now always imported at 100% zoom in Excel, avoiding the possibility (mostly with charts, but still infrequent) that the picture changes upon updating links due to zoom alone.
  • Link Wizard now shows time of last update in the system's date / time format for better international support.
  • Improved compatibility of several dialogs with larger system font sizes.

3.5.2

  • Improved linking to Excel cell ranges, including more reliable linking to print areas and better use of existing range names to establish links.
  • Improved Link Wizard interface now shows linked range names and last known addresses.
  • Improved ribbon interface / functionality.
  • Minor bug fixes.

3.5.1

  • Suppresses messages regarding range names when importing cells as pictures as a result of changes made in v3.5.0.

3.5.0

  • Importing cells as pictures and updating linked pictures is now faster and involves no window flicker.
  • When importing cells as pictures, external data sourced with third-party functions no longer shows formula errors in the output in certain scenarios.
  • The remove borders when importing option now only removes chart borders, not cell borders.
  • When importing cells as a table, fonts are now recolored to the default font color rather than black.

Version 3.4

3.4.1

  • Fixed PowerPoint 2010 / 2007 bug preventing Content Library images from being inserted into the selected picture placeholder.

3.4.0

  • Slides inserted from the active template now show slide numbers if applicable.
  • Images inserted from Content Library are now inserted into the selected picture placeholder.
  • Links no longer update automatically when editing links.
  • Fixed bug that prevented publishing metafile images to the content library.
  • Fixed Template Wizard bug that could prevent removing special slide designation.
  • Minor updates.

Version 3.3

3.3.2

  • Link Wizard no longer falsely reports that chart links are broken when verifying links.
  • Fixed bug prompting for library path when publishing content and templates even if library path was already set.
  • Fixed bug that could cause importing cells as a picture to fail if cells contain multiple font colors.
  • Minor updates.

3.3.1

  • Removed preservation of certain formatting (introduced in v3.3.0) when updating linked shapes due to PowerPoint bugs that may erroneously apply shadows.
  • Fixed slide numbering bug.
  • Minor updates.

3.3.0

  • Certain formatting (e.g. shadow, reflection, glow) applied to linked shapes after linking is now preserved when links are updated.
  • Fixed bug that could place updated linked shapes in the wrong z-order when updating.
  • Fixed bug that could paste linked shapes on the wrong slide when editing links on multiple slides in Link Wizard.
  • Fixed bug that placed imported charts in the wrong z-order when a destination shape is pre-selected.
  • Fixed bug preventing updating charts linked to cells that are contained within placeholders.
  • Proofing tools now ignore "etc." when checking bullet punctuation.
  • Minor enhancements and bug fixes.

Version 3.2

3.2.6

  • Improved ability to connect to the Internet through a proxy server.
  • Fixed Show in Folder bug that opened the wrong folder when file paths contained certain characters.
  • Minor updates.

3.2.5

  • Now include bullet punctuation (e.g. ".") in agenda items on tables of contents or flysheets.
  • Fixed bug that could cause updating linked shapes to fail.
  • Fixed bug that could cause importing cells on a protected worksheet to fail.
  • Improved error handling.
  • Minor updates.

3.2.4

  • Support for PowerPoint 2016.
  • More reliably quits Excel after updating linked shapes when Excel was not previously open, avoiding orphaned Excel instances.
  • Fixed bug that pasted all linked shapes on a single slide when changing the source for shapes on multiple slides in Link Wizard.
  • Other minor Link Wizard bug fixes.
  • Fixed bug that could increase file size slightly with each linked shape update.

3.2.3

  • Default agenda settings can now be shared across an organization.
  • Minor updates.

3.2.2

  • Improved login experience, including fewer forced logouts, no login prompts while offline, and more.
  • You can now view the full Macabacus tab when working offline.
  • Minor bug fixes and other updates.

3.2.1

  • Macabacus now prompts to relink to an open file with the same name as the source file, but a different path, when updating links.
  • Performance improvements and bug fixes in Edit Link dialog and other linking functionality.
  • Improved method of designating "special" slides in Macabacus-enabled templates to support better integration with native functionality.

3.2.0

  • New "page intentionally left blank" slide in Macabacus-enabled templates used primarily to avoid printing flysheets on the back of pages when duplex printing.
  • "Page intentionally left blank" slides can be inserted into presentations as needed for duplex printing with the click of a button.
  • New option to insert "page intentionally left blank" slides into presentations as needed for duplex printing when generating PDFs.
  • New option to apply the rotation of a copied shape to selected shapes.
  • Fixed bug that prevented opening the Edit Link dialog from within Link Wizard with one linked shape / slide checked.
  • Minor ribbon updates.

Version 3.1

3.1.1

  • Fixed bug preventing section titles on content slides from updating properly in some situations.

3.1.0

  • Added new Stack Right and Stack Down shape tools. Renamed Stack Horizontally and Stack Vertically to Stack Left and Stack Right, respectively.
  • Agenda / table of contents improvements and bug fixes.
  • Changed how shapes are designated as section titles in Macabacus-enabled presentation templates (requires minor template changes for compatibility).
  • Minor library functionality updates.
  • Minor ribbon updates.

Version 3.0

3.0.1

  • Pictures created when importing large ranges are no longer truncated under certain conditions.
  • Removed "Unable to copy the Macabacus Chart Gallery" message that might appear when starting PowerPoint.
  • New warning when trying to import Excel with multiple Excel instances running.

3.0.0

  • Major overhaul of table of contents / agenda tools that affords greater customization flexibility, lets you include page numbers and slide titles, updates automatically when section topics change, integrates deeply with native PowerPoint sections, and much more. Templates used with prior versions of Macabacus must be updated to utilize these new features. This change does not apply to PowerPoint 2007.
  • Slide titles displaying section / subsection topics on content slides now update automatically when topics change.
  • Improved Slide Numbers dialog interface, with new sequential numbering option that ignores slides on which you choose not to display slide numbers.
  • New Select Match tool that lets you select shapes with properties (e.g. size, position, formatting, etc.) similar to another shape.
  • Improved slide master management now avoids duplicate layouts in your presentations.
  • Ribbon and other interface updates.
  • Improved error handling and reporting.

Version 2.3

2.3.0

  • Now add charts with pre-structured data from the Content Library to your presentations.
  • Fixed Content Library pane bugs related to library/content filter toggles and text searching.
  • Illegal characters in slide text no longer prevent publishing slide content.
  • Fixed bug requiring PowerPoint to be run as admin when opening presentations in the team Content and Template Libraries.

Version 2.2

2.2.4

  • Minor updates to support inclusion of charts in Content Library.

2.2.3

  • Minor ribbon update.

2.2.2

  • Minor bug fix for Content Library pane affecting text search when slide content visibility is toggled off.

2.2.1

  • Minor ribbon updates and other improvements.

2.2.0

  • Improvements to Insert Content dialog, including major interface upgrades and the ability to search for content.
  • Now save shared settings in the cloud.
  • Improved behavior for Increase / Decrease Line Spacing tools.
  • Fixed Save Up bug that could save presentations to the wrong folder.
  • Minor ribbon and context menu updates / fixes.

Version 2.1

2.1.1

  • Minor bug fixes and ribbon interface updates.

2.1.0

  • Major update to proofing tools that includes new task pane for easier navigation of errors and inconsistencies, improved proofing algorithms, new millions / billions abbreviation consistency checks, bug fixes, and more.
  • Improved Link Wizard interface that displays slide number of linked shapes and section titles.
  • Fixed bug that recolored white fonts black upon importing from Excel in some cases.
  • Minor bug fixes and interface updates.

Version 2.0

2.0.8

  • Improved matching of original workbook colors when importing cells as a picture in some cases.

2.0.7

  • Improved font recoloring in tables imported from Excel ranges.
  • Edit Link dialog interface improvements.
  • Minor performance improvements.

2.0.6

  • When importing cells from Excel, Macabacus now only recolors fonts black that have AutoColor font colors.
  • Fixed bug that could have caused linked charts to update from the wrong chart in a workbook after changing the source workbook.

2.0.5

  • Added proofing language check to proofing tools.
  • Fixed Link Wizard bug that reported links as broken after clicking the Verify Link button with the source workbook initially closed.
  • Added workaround for PowerPoint 2007 bug that caused cells imported as tables to appear in the wrong position on the slide upon updating links.

2.0.4

  • Added zoom-on-hover capability to slide thumbnails in the Insert Content dialog.
  • Added tool to analyze each slide's contribution to total file size.
  • Minor bug fixes.

2.0.3

  • Fixed error reporting bugs.
  • Eliminated screen flicker when emailing selected slides.
  • Minor Library Manager interface changes.

2.0.2

  • Fixed bugs that produced unexpected results when certain errors were encountered using various tools.
  • Improved compatibility when importing settings from older versions of Macabacus.

2.0.1

  • Fixed permission issue with the team library.

2.0.0

  • Major overhaul to Macabacus libraries that simplifies library management, improves performance, and lays the foundation for future functionality. Those upgrading from v1.x should be advised that the new library framework is not backward-compatible, meaning that you may need to rebuild previously created content and template libraries.
  • Introduced a third library; there are now personal, team, and company libraries.
  • Simplified enterprise deployment.
  • Faster loading of thumbnail images in the Insert Content dialog.
  • Bug fixes.

Version 1.1

1.1.4

  • Fix bug affecting linking to workbooks in virtual folders and some network drives.

1.1.3

  • Bug fix affecting configuration of the shared content and template libraries.

1.1.2

  • Fixed bug that added extra slides to the presentation when emailing selected slides or duplicating a presentation while Macabacus is set to use the active template for all new presentations.
  • Fixed emailing selected slides in PowerPoint 2007.
  • Error logging and reporting bug fixes.
  • Macabacus will try another directory when saving shared libraries manifests to a temp directory for which the user is not properly permissioned.

1.1.1

  • Improved error logging and reporting.
  • Minor interface updates.

1.1.0

  • Added new Line Spacing Increase / Decrease tools to the ribbon.
  • Improved fill color behavior when individual table cells are selected.
  • Fixed bug preventing update of a chart linked to an Excel range.
  • Software update notifications can be disabled and/or configured in Shared Settings.
  • Send usage statistics can be disabled and/or configured in Shared Settings.
  • Minor bug fixes.

Version 1.0

1.0.2

  • Fixed bug that could prevent Application Settings dialog from opening.
  • Fixed bugs in Explorer and Tab Browser.

1.0.1

  • Fixed bugs in Explorer and Tab Browser.
  • Added support for PowerPoint 2007.
  • Fixed incorrect Sign In / Out button enabled state after sign-in.

1.0.0

  • Released Macabacus tools for PowerPoint from beta.
  • New tools added and tab interface changes.
  • Bug fixes.

Macabacus
for Word

Version 1.6

1.6.14

  • Minor ribbon updates.

1.6.13

  • Additional authentication improvements.
  • Now import Macabacus settings saved to the cloud.

1.6.12

  • New, simpler software activation method and related authentication improvements.
  • Drag-and-drop content from the Library Pane into your documents.
  • Specify an internal email address for Macabacus support inquiries.

1.6.11

  • Sample library now installs with Google material icons.
  • Macabacus settings can be uploaded automatically to the cloud and downloaded in Admin Console.

1.6.10

  • Updated library controls in ribbon.
  • Minor bug fixes and updates.

1.6.9

  • Minor update.

1.6.8

  • Reliability improvements when importing cells/charts as pictures and updating linked pictures.

1.6.7

  • Improved support for Office applications running on terminal servers (Macabacus now ignores multiple instances of Office apps when terminal servers are detected and allows import operations to proceed).

1.6.6

  • Minor Link Wizard interface improvements.
  • Sign In/Out and Activate buttons are now grouped in a new menu on the ribbon.

1.6.5

  • Addressed issue with some third party UDFs showing formula errors in imported pictures and other shapes.

1.6.4

  • Added new Copy Path to document tool.
  • Minor updates.

1.6.3

  • Improved error handling and messaging.
  • Linking to workbooks that have never been saved (e.g., "Book1") is no longer possible.
  • Added ability to hide tools in beta testing.

1.6.2

  • Fixed bug that could cause Shortcut Manager to appear blank after updating from certain versions.

1.6.1

  • Shortcut settings can now be shared.
  • Consolidation of all settings into a single XML file, eliminating separate shortcut setting files.
  • Improved recognition of network drives for library caching purposes.
  • Minor updates.

1.6.0

  • Remote (network) libraries can now be cached locally and automatically at a customizable frequency.
  • Library pane loads large quantities of shapes, images, etc. much faster.
  • Added ability to filter links in Link Wizard.
  • Minor updates and bug fixes.

Version 1.5

1.5.13

  • Added ability to import cells and charts to a single cell in a Word table.
  • Library manifests now use relative paths to support library portability and future functionality.
  • Minor updates.

1.5.12

  • Eliminated multiple logout notifications.

1.5.11

  • Updated manual is now included as a PDF.

1.5.10

  • Ribbon palettes now support fewer than 56 colors.

1.5.9

  • Minor updates.

1.5.8

  • Fixed bug that could produce invalid manifest XML when republishing items to the library.

1.5.7

  • Added ability to republish existing presentation, model, and document templates.
  • Minor updates.

1.5.6

  • Fixed bug that prevented headers / footers from appearing when duplicating documents and inserting documents from the library.
  • Speed / screen flicker improvements when duplicating documents and inserting documents from the library.
  • Published document templates now belong to a document group for improved categorization.
  • Improved document template publishing, including batch publishing.
  • Rename library item descriptions in Library Manager.

1.5.5

  • Addressed inability to update links to Excel in Word 2016, only.

1.5.4

  • Fixed bug preventing import of shared color palette settings published prior to v1.5.0.

1.5.3

  • View Source can now recognize a workbook open in Excel as the link source if it has the same name, but different path, as the source workbook.
  • Improved link update behavior for linked tables and links to charts when the source range / chart is hidden.
  • Minor updates to linking functionality.

1.5.2

  • Links no longer update automatically when editing links.
  • Macabacus no longer expands grouped / collapsed rows and columns when updating links.
  • Fixed bugs related to updating links to hidden cell ranges.
  • Fixed failure to unhide hidden columns in the source range when using View Source due to bug introduced in v1.5.1.
  • Minor updates.

1.5.1

  • Importing / updating linked pictures is now faster when the source range contains hidden cells and font recoloring is enabled.
  • Formula error warnings when importing cells / updating links now only appear if the errors are visible in the source range.
  • Improved identification of potentially newer versions of source files when updating links.
  • Improved View Source behavior when the source range is hidden.
  • Link Wizard now shows the correct source file path after updating links when you change the source file.
  • Fixed bug preventing display of Standard Sizes in the Common Settings dialog.
  • Fixed bug that could open multiple Excel windows when viewing a linked shape's source in rare cases.
  • Minor updates.

1.5.0

  • Added new Document Library for storing frequently used document templates.
  • Added support for multiple color palettes.
  • Duplicated documents now preserve the original color theme.
  • Minor ribbon and other updates.

Version 1.4

1.4.8

  • Minor updates.

1.4.7

  • Restores Word window if initially minimized when exporting from Excel to Word.
  • Simplified the Import from Excel menu.
  • Minor updates.

1.4.6

  • Added ability to attach a diagnostics report to an email to Macabacus Support.
  • View Source now works when the source workbook's window is minimized.
  • Improved, more meaningful error messages when importing / updating linked shapes fails.
  • Minor ribbon and other updates.

1.4.5

  • Fixed Common Settings dialog bug affecting Standard Sizes when the comma is used as the system decimal symbol.
  • Fixed Link Wizard bug causing information in some columns to be blank.

1.4.4

  • Fixed bug introduced in v1.4.3 that could prevent importing cells as a picture.

1.4.3

  • Linked pictures are now always imported at 100% zoom in Excel, avoiding the possibility (mostly with charts, but still infrequent) that the picture changes upon updating links due to zoom alone.
  • Link Wizard now shows time of last update in the system's date / time format for better international support.
  • Improved compatibility of several dialogs with larger system font sizes.

1.4.2

  • Improved linking to Excel cell ranges, including more reliable linking to print areas and better use of existing range names to establish links.
  • Improved Link Wizard interface now shows linked range names and last known addresses.
  • For Word 2007, only, several Link Wizard bug fixes.
  • Minor bug fixes.

1.4.1

  • Suppresses messages regarding range names when importing cells as pictures as a result of changes made in v1.4.0.

1.4.0

  • Importing cells as pictures and updating linked pictures is now faster and involves no window flicker.
  • When importing cells as pictures, external data sourced with third-party functions no longer shows formula errors in the output in certain scenarios.
  • The remove borders when importing option now only removes chart borders, not cell borders.
  • When importing cells as a table, fonts are now recolored to the default font color rather than black.

Version 1.3

1.3.15

  • Fixed minor bug related to attaching an unsaved document to an email.

1.3.14

  • Fixed bug that prevented publishing metafile images to the content library.
  • Minor updates.

1.3.13

  • Link Wizard no longer falsely reports that chart links are broken when verifying links.
  • Fixed bug prompting for library path when publishing content even if library path was already set.
  • Fixed bug that could cause importing cells as a picture to fail if cell color information is missing.
  • Fixed bug that prevented creating a PDF of the entire document.
  • Fixed bug that opened generated PDFs twice.
  • Minor updates.

1.3.12

  • Minor updates.

1.3.11

  • Minor enhancements and bug fixes.

1.3.10

  • Improved ability to connect to the Internet through a proxy server.
  • Fixed Show in Folder bug that opened the wrong folder when file paths contained certain characters.
  • Minor updates.

1.3.9

  • Fixed bug that could cause importing cells on a protected worksheet to fail.
  • Improved error handling.
  • Minor updates.

1.3.8

  • Support for Word 2016.
  • More reliably quits Excel after updating linked shapes when Excel was not previously open, avoiding orphaned Excel instances.
  • Minor Link Wizard bug fixes.

1.3.7

  • Minor updates.

1.3.6

  • Improved login experience, including fewer forced logouts, no login prompts while offline, and more.
  • You can now view the full Macabacus tab when working offline.
  • Other minor updates.

1.3.5

  • Macabacus now prompts to relink to an open file with the same name as the source file, but a different path, when updating links.
  • Performance improvements and bug fixes in Edit Link dialog and other linking functionality.

1.3.4

  • Macabacus now recognizes text links in document headers / footers.
  • Fixed bug that could prevent switching to Word upon exporting ranges / charts from Excel.
  • Fixed bug that prevented opening the Edit Link dialog from within Link Wizard with one linked shape checked.

1.3.3

  • Minor library functionality updates.

1.3.2

  • Pictures created when importing large ranges are no longer truncated under certain conditions.
  • Removed "Unable to copy the Macabacus Chart Gallery" message that might appear when starting Word.
  • New warning when trying to import Excel with multiple Excel instances running.

1.3.1

  • Minor interface updates.
  • Minor bug fixes.

1.3.0

  • Now add charts with pre-structured data from the Content Library to your documents.
  • Fixed Content Library pane bugs related to library/content filter toggles and text searching.

Version 1.2

1.2.2

  • Minor updates to support inclusion of charts in Content Library.

1.2.1

  • Hotkey Manager now shows descriptions of shortcuts in tooltips.
  • Minor ribbon improvements.

1.2.0

  • Improvements to Insert Content dialog, including major interface upgrades and the ability to search for content.
  • Fixed bug affecting the ability to back up and restore shortcut settings.

Version 1.1

1.1.2

  • Minor improvements.

1.1.1

  • Now save shared settings in the cloud.
  • Fixed Save Up bug that could save documents to the wrong folder.
  • Minor ribbon updates.

1.1.0

  • Added ability to import a single cell as text.
  • Minor bug fixes and ribbon interface updates.

Version 1.0

1.0.2

  • Fixed bug that recolored white fonts black upon importing from Excel in some cases.

1.0.1

  • Improved matching of original workbook colors when importing cells as a picture in some cases.

1.0.0

  • Released from beta.

Macabacus Lite

Version 6.0

6.0.0 (27 Oct 2015)

  • Numerous performance and behavioral improvements and bug fixes reflecting certain recent updates to Macabacus Pro / Suite tools for Excel.
  • Updated ribbon interface that mimics the ribbon interface in the full version of Macabacus.
  • Addition / removal of certain tools.

Version 5.0

5.0.1

  • Fixed bug affecting row/column unhide/ungroup.
  • Removed Excel 2003 menus and toolbars.

5.0.0

  • Performance improvements to several row/column tools, particularly when operations involve large numbers of rows/columns.
  • Performance improvements to Show All Precedents/Dependents.
  • Apply Paintbrush produces more intuitive results and more closely emulates native Excel paste operations.
  • Fixed a bug affecting customized shortcut keystrokes beginning with Alt Shift.
  • Fixed a bug affecting row/column insertion while in Copy mode.
  • Fixed a bug that prevented Smart Hide from operating on columns to the right of Excel's UsedRange.
  • Other minor performance improvements, bug fixes, and ribbon updates.

Version 4.2

4.2.2

  • Minor performance improvements for some row/column operations.
  • Removed deprecated features.

4.2.1

  • Removed shortcut keystroke for Border Theme Cycle, which was deprecated in version 4.2.0.

4.2.0

  • Macabacus Lite no longer forces manual calculation mode upon opening Excel in some cases.
  • Fixed bug affecting Go To Min/Max tools when used with some number formats.
  • Updated icons in Excel 2013 to conform appearance.
  • Removed some non-core tools.

Version 4.1

4.1.3

  • Fixed a bug that produced an error message when Clean Up Used Ranges was run on a blank worksheet.

4.1.2

  • Worked around an Excel® deficiency that changes number formats of cells when a native decimal increase/decrease operation is performed on a selection of cells containing multiple number formats. Macabacus' Increase/Decrease Decimals tools now resolve this deficiency.
  • Fixed a bug causing Excel® to freeze when an entire row or column is selected and an Increase/Decrease Decimals operation is performed.
  • Performance enhancements.

4.1.1

  • Faster Smart Precedents performance when auditing large, circular models.
  • Fixed a bug in Fill Cycle that prevented cycling when the first or last color in the cycle was white.
  • Removed an error message when Macabacus is unable to set shortcuts at startup.

4.1

  • Added Hide Page Breaks tool.
  • Accelerator keys on the Macabacus tab conform to Macabacus Pro where applicable, and menu accelerator keys for classic menus are the same as those in Excel® 2003.
  • Reorganized parts of the ribbon to conform to Macabacus Pro.
  • Performance enhancements and bug fixes.

Version 4.0

4.0.4

  • 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 indiscriminately 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

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

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

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.