View Cart

Home

About Add-ins.com

Contact us

Order,
Download &
Product Support

Money back guarantee

Customer feedback

New Products
& Upgrades

Download Purchased software

Excel Problems
& Solutions

Site search

 

INDIVIDUAL PRODUCTS:

Macro Books

Time Saving Products

Charting Products

Data Products

Analysis Products

Specialty Products

Free Products

 

PRODUCT COLLECTIONS:

Visual Basic Collection

Productivity Suite


  

Consolidation Assistant Improvements

Latest Release: 2.08 - Excel 97-2007 compatible

How to upgrade to the latest version
Product information

Upgrade EXE for Version 2 users - Version 2 must be installed for the upgrade to install to the latest release

Latest improvements:

  • Feb 23, 2008 - Modified to detect if a workbook is protected when selected a new worksheet for a multi-worksheet range consolidation.
  • Feb 8, 2008 - Fixed a problem for users who have upgraded Excel 2003 to SP3.  Only a few such users are experience a problem and is due to an installation problem in Excel caused by SP3.
  • Jan 29, 2008 - Added an option to consolidate CSV files and not automatically convert to columns.  This allows the user to use Data, Text to Column to control the data conversion.
  • July 3, 2007 - Digitally signed our installation exe and add-in using a software code signing certificate from Thawte to add another level of security and confidence in our products.  It allows users to maintain macro security on the high security setting in Excel and still run our add-ins. 
  • June 19, 2007 - Fixed a problem with consolidating worksheets if one of the worksheets has a data list set.
  • April 3, 2007 - Fixed a problem where the consolidations of multiple sheets into one did not recognize the additional rows available in Excel 2007
  • March 21, 2007 - Version 2 released which is compatible with Excel 2007 and backward compatible to Excel 97
  • 2006
    • Modified to eliminate an extra blank row that was being added when consolidating all worksheets in multiple workbooks.
    • Modified the feature that extracts data from multiple workbooks so that one can specify up to 10 ranges (from any sheets) to be extracted.
    • Modified to prevent auto running macros from running when workbooks opened for consolidation.
    • Improved dialogs and additional options added
    • fixed a problem in release 1.39 with copying multiple sheets to more than one duplicate destination sheet.
    • Modified to handle cells containing more than 255 characters
    • Minor menu improvements
    • Improved handling of column widths and cell formats and hidden rows
    • Modified to allow search for a partial cell string when searching multiple sheets for matching text
    • Added an option to retain hidden rows and columns as hidden when consolidating sheets into a workbook.
    • Modified to allow select of a set of sheets versus all sheets when extracting data from a workbook
    • Modified to fix a problem that occurred in some consolidation instances when consolidating to different workbooks at one time
 
Copyright 2008 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Macro Systems.
Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation