Add-ins Collection for Microsoft Excel

What's new

Feature Tour

Version 2012.3 (22-Feb-2012)

• Improved: Single executable for 12 add-ins that reduces loading speed. The Collection loads as one add-in.

Version 2012.2 (02-Feb-2012)

• Added: Combine Rows Wizard for Microsoft Excel

Version 2012.1 (16-Jan-2012)

• UPDATED: Collection version number system.
• UPDATED: Cell Cleaner for Excel to version 1.1
  • ADDED: new non-printing unicode characters can be removed using the "Remove unwanted characters" option.
• UPDATED: Advanced Find & Replace to version 4.5.4
  • ADDED: Option to search within selection.
  • FIXED: Data export from worksheets with long names.

Version 2.6.4 (30-Nov-2011)

• ADDED: Excel 2010 Click-to-Run version support.

Version 2.6.3 (01-Nov-2011)

• IMPROVED: The add-in functionality loads when the add-in, not Excel, is started.

Version 2.6.2 (18-Oct-2011)

• ADDED: Cell Cleaner for Microsoft Excel version 1.0
• Added: Excel color schemes support.
• Updated: Measurement Units Converter to version 1.0.7
  • ADDED: Quick unit name filter
    • ADDED: Numbers to words conversion
    • ADDED: SI prefix conversion
    • ADDED: Numbers within text conversion
    • FIXED: Pane freezing after editing a cell
• UPDATED: Advanced Find & Replace to version 4.5.1
  • FIXED: Pane freezing after editing a cell.
• Duplicate Remover to version 2.6.6
  • Excel locking when selecting a range.
• UPDATED: Fuzzy Duplicate Finder to version 3.5.1
  • FIXED: Pane freezing after editing a cell.
• UPDATED: Merge Cells Wizard to version 3.0.6
  • FIXED: Cell range selection limit.
• UPDATED: Merge Tables Wizard to version 2.6.6
  • FIXED: Excel locking when selecting a range.
• UPDATED: Random Sorter to version 1.0.1
  • FIXED: Pane freezing after editing a cell.
• UPDATED: Workbook Manager to version 1.0.1
  • FIXED: Pane freezing after editing a cell.

Version 2.5 (17-Jun-2011)

• Added: Microsoft Excel 2010 64-bit support for all add-ins.
• Added: Measurement Units Converter for Microsoft Excel version 1.0
• Added: Random Sorter for Microsoft Excel version 1.0
• Removed: Autoformat for Excel PivotTables, Color Manager for Excel, Style Manager for Excel

Version 2.4.5 (21-Apr-2011)

• Updated: Fuzzy Duplicate Finder to version 3.5.0
  • ADDED: Support for 64-bit version of Microsoft Excel 2010.
  • • ADDED: Max number of different characters is increased to 10.
    • ADDED: A possibility to exclude from search cells or words with fewer than the defined number of characters.
    • A possibility to split data in each cell into words and process them separately.
• Split Names to version 1.5
  • ADDED: Support for 64-bit version of Microsoft Excel 2010.

Version 2.4 (10-Feb-2011)

• Added: Workbook Manager for Microsoft Excel version 1.0
• Updated: Merge Tables Wizard to version 2.5
  • ADDED: Support for 64-bit version of Microsoft Excel 2010.
• Updated: Advanced Find & Replace to version 4.5
  • ADDED: Support for 64-bit version of Microsoft Excel 2010.
  • ADDED: Search time is greatly reduced.

Version 2.3 (21-Dec-2010)

• Updated: Duplicate Remover to version 2.5
  • ADDED: Support for 64-bit version of Microsoft Excel 2010.
• Updated: Merge Cells Wizard to version 3.0
  • ADDED: Support for 64-bit version of Microsoft Excel 2010.
• Updated: Random Generator to version 3.0
  • ADDED: Support for 64-bit version of Microsoft Excel 2010.
• Advanced Find & Replace to version 4.5
  • ADDED: Option for selecting the worksheets to search in by default: "All sheets" or "Active only".
  • ADDED: Restoring the last selection of worksheets to search in after reopening the add-in.
  • ALTERED: search results navigation is improved.

Version 2.2 (20-Jul-2010)

• Added: Split Names for Microsoft Excel 1.0

Version 2.1 (15-Jun-2010)

• Updated: Duplicate Remover to version 2.1
  • ADDED: "Add a status column" action for values that adds the "Duplicate Remover marks" column to the end of the table, which marks the rows with found values as 'Duplicate', 'Duplicate/1st occurrence', 'Unique' or 'Unique/1st occurrence'.
  • UPDATED: Merge Cells Wizard to version 3.0.3
    • ADDED: "Wrap text" option.
      • ADDED: "Create a backup copy of the worksheet" option.
      • ALTERED: Improved "Separate values with" option.

Version 2.0 (20-May-2010)

• Updated: Advanced Find & Replace to version 4.0
  • ADDED: Support for Microsoft Excel 2010 RTM.
• Updated: Duplicate Remover to version 2.0
  • ADDED: Support for Microsoft Excel 2010 RTM.
• Updated: Fuzzy Duplicate Finder to version 3.0
  • ADDED: Support for Microsoft Excel 2010 RTM.
• Updated: Merge Cells Wizard to version 3
  • ADDED: Support for Microsoft Excel 2010 RTM.
• Updated: Merge Tables Wizard to version 4
  • ADDED: Support for Microsoft Excel 2010 RTM.
• Updated: Random Generator to version 4
  • ADDED: Support for Microsoft Excel 2010 RTM.
• Updated: Style Manager to version 4
  • ADDED: Support for Microsoft Excel 2010 RTM.
• Updated: Explorer for Excel to version 3
  • ADDED: Support for Microsoft Excel 2010 RTM.
• Updated: Autoformat for Excel PivotTables to version 2
  • ADDED: Support for Microsoft Excel 2010 RTM.

Version 1.9 (30-Apr-2010)

• Updated: Duplicate Remover to version 1.9.12
  • IMPROVED: Beta support for Microsoft Excel 2010 beta.
    • FIXED: Incorrect work in Windows XP and Windows Vista if data contain dashes or apostrophes.
• Updated: Merge Tables Wizard to version 1.8.9
  • IMPROVED: Beta support for Microsoft Excel 2010 beta.
  • FIXED: Incorrect work in Windows XP and Windows Vista if data contain dashes or apostrophes.

Version 1.8 (25-Feb-2010)

• Updated: Advanced Find & Replace to version 3.14
• Updated: Explorer for Excel to version 2.0

Version 1.7.9 (24-Dec-2009)

• Updated: Merge Tables Wizard to version 1.8.4
  • ADDED: A filter to show columns with a given status only at the "Select the action for matching data" step. A very useful option when working with large worksheets.
• Updated: Random Generator to version 2.1.5
  • ALTERED: The random number generator algorithm is changed to Mersenne Twister: A 623-Dimensionally Equidistributed Uniform Pseudo-Random Number Generator.
    • ALTERED: The speed of generating non-unique values is increased by a few times.
    • ALTERED: The integer range is extended from -2^31 to 2^31-1.
    • FIXED: Improved compatibility with Excel 2010 and Windows 7.
    • FIXED: Some minor bugs.

Version 1.7.8 (23-Oct-2009)

• Updated: Random Generator to version 2.1
  • ADDED: "Entire rows" and "Entire columns" sorting options in the "Sort" tab.
    • ADDED: Ability to randomly select rows from a range ("Select" tab).

Version 1.7.5 (25-Sept-2009)

• Updated: Merge Tables Wizard to version 1.8.1
  • ADDED: "Update only if cells from Lookup Table contain data" option. If this option is enabled, a given cell in the Master Table will be updated only if the matching cell from the Lookup Table contains any data.
    • ADDED: "Update only empty cells in Master Table" option. If this option is enabled, a given cell in the Master Table will be updated only if this cell doesn't contain any data.
• Updated: Duplicate Remover to version 1.9.2
  • ADDED: "Ignore empty cells" option for "Search in a single list" and "Comparing two tables" modes.

Version 1.7.4 (20-Aug-2009)

• Updated: Merge Tables Wizard to version 1.7.9
  • ADDED: "Ignore extra spaces in matching columns" option.
• Updated: Duplicate Remover to version 1.9
  • ADDED: "Ignore extra spaces in matching columns" option.
    • ADDED: 2 new options for searching in a single list: "Duplicates + 1st occurrence" and "Uniques + 1st occurrence".

Version 1.7.3 (15-Jul-2009)

• Updated: Duplicate Remover to version 1.8
  • ADDED: Quick Search feature that allows removing duplicates from a selected worksheet in 2 clicks.

Version 1.7.2 (21-Apr-2009)

• Updated: Merge Tables Wizard to version 1.7.6
  • ADDED: Automatic selection of matching columns when all columns from the Lookup table have the same names in the Master table.

Version 1.7.1 (15-Feb-2009)

• Updated: Merge Tables Wizard to version 1.7.4
  • FIXED: "Out of present range" error when the entire sheet was selected in Excel 2007 at the Duplicate Remover start-up.
    • FIXED: Error with updating data in the master worksheet if the Normal style was changed.
• Updated: Duplicate Remover to version 1.7.10
  • FIXED: "Out of present range" error when the entire sheet was selected in Excel 2007 at the Duplicate Remover start-up.

Version 1.7 (31-Oct-2008)

• Updated: Random Generator to version 2.0
  • ADDED: Unique values option for integers, real values, dates and custom lists.
    • ADDED: Ability to fill the selected range with values from the custom lists in a random order.
    • ADDED: Ability to create your own custom lists.
    • ADDED: Ability to generate random strings from a selected character(s) set: A-Z, a-z, 0-9, special, or your own custom set.
    • ADDED: Ability to randomly sort cells in rows, columns or an entire range.
• Updated: Duplicate Remover to version 1.7.6
  • FIXED: Incorrect selection of the entire column in the R1C1 mode.
    • FIXED: Incorrect displaying non-latin characters in Wizard messages.
    • ADDED: Generating random strings by mask.
    • ADDED: Hexadecimal character set for generating random strings.
• UPDATED: Merge Tables Wizard to version 1.7.0
  • FIXED: Incorrect selection of the entire column in the R1C1 mode.
    • FIXED: Incorrect displaying non-latin characters in Wizard messages.
    • FIXED: Incorrect work in Excel 2007, when one of the workbooks was in the Excel 2003 format.

Version 1.6.7 (16-Aug-2008)

• Updated: Duplicate Remover to version 1.7.5
  • FIXED: "Application.InputBox returns value of unexpected type." error if the worksheet contained Conditional Formatting with the "Formula Is" condition.
• Updated: Merge Tables Wizard to version 1.6.9
  • FIXED: "Application.InputBox returns value of unexpected type." error if the worksheet contained Conditional Formatting with the "Formula Is" condition.

Version 1.6.5 (15-Jul-2008)

• Updated: Duplicate Remover to version 1.7.3
  • ADDED: Checking for multiple sheets selection.
• Updated: Merge Tables Wizard to version 1.6.8
  • FIXED: Error when cells in the master table had some arithmetical formulas that used data from updated cells. #value appeared if updated cells were blank or contained "" data.
    • ADDED: Checking Master & Lookup tables for merged cells.
    • ADDED: Checking Master & Lookup tables for Outline.
    • ADDED: Checking for multiple sheets selection.
    • IMPROVED: Updated cells coloring algorithm in large workbooks.
    • ADDED: If the Master & Lookup tables in the same worksheet, the additional checking of the Lookup table location isperformed to prevent Lookup table from being corrupted.

Version 1.6 (20-Jun-2008)

• Updated: Duplicate Remover to version 1.7
  • ALTERED: An improved alghoritm of finding and removing duplicates.
    • FIXED: Error "Union method of Application class failed" in Excel 2007.
    • FIXED: Minor bugs when working with Excel 2007.
• Updated: Merge Tables Wizard to version 1.6.2
  • FIXED: Error "Setting Value property of Range class failed. The source array of values contain large strings."
    • FIXED: Error when selecting the "Update values in" action, a matching column was not available.
• Updated: Style Manager to version 2.0

Version 1.5 (18-May-2008)

• Updated: Duplicate Remover to version 1.6
  • FIXED: Error "Could not convert variant of type (Error) into type (Double)" in R1C1 reference style mode.
• Updated: Merge Tables Wizard to version 1.6
  • FIXED: Error "Could not convert variant of type (Error) into type (Double)" in R1C1 reference style mode.
    • FIXED: Filtered range was not automatically detected in non-English Excel localizations.
    • ADDED: Check of matching columns summary length (cannot exceed 255 symbols).
• Updated: Color Manager to version 2.0

Version 1.4 (16-Apr-2008)

• Updated: Merge Tables Wizard to version 1.5.8
  • ADDED: For newly added rows, the format of the last row of the Master table is applied.
    • FIXED: "Invalid number of Parameters error" error if a worksheet contained some style with blank name.
    • FIXED: "Insert Method of Range Class Failed" error in filtered tables.
• Updated: AutoFormat for Excel PivotTables to version 2.0

Version 1.3.5 (28-Feb-2008)

• Updated: Merge Tables Wizard to version 1.5
  • ADDED: The ability to insert non-matching rows from the Lookup Table after all rows of the Master Table (in the appropriate columns).
    • ADDED: Automatical detection of columns that may be updated ("update values in" action will be applied).
    • ADDED: Some changes in the user interface.

Version 1.3.1 (12-Oct-2007)

• Updated: Duplicate Remover to version 1.5
  • ADDED: Adding a number to the column name in case two or more columns have the same names.
    • ADDED: Improved processing of Query Table.
    • FIXED: Converting formulas to values in a processed table.
• Updated: Advanced Find & Replace to version 3.12
  • ADDED: Full support of Unicode.
  • ADDED: Ability to bind / unbind starting the add-in to Ctrl+F.
• Updated: Merge Cells Wizard to version 2.1
  • ADDED: Skip empty cells option.
    • FIXED: Minor bugs when working with Excel 2007.

Version 1.3 (09-Sep-2007)

• Updated: Duplicate Remover to version 1.4
  • FIXED: "OLE Error" when comparing two identical lists.
    • FIXED: A bug when working with Excel List.
    • FIXED: Access violation when running the wizard with the cursor placed on an empty cell right to a filtered table.
• Updated: Merge Tables Wizard to version 1.4
  • ADDED: Adding a number to the column name in case two or more columns have the same names.
    • ADDED: "Unselect All" button for the "Matching columns" list
    • ADDED: Auto selecting matching columns when both tables have headers.
    • ADDED: The ability to clear background color of Non-updated cells
    • FIXED: Bug when working with workbooks whose file names contained an apostrophe.
    • FIXED: Bug in updating values if Autofilter was applied to the Main Table.
    • FIXED: Some minor bugs when working in Excel 2003.
• Updated: Fuzzy Duplicate Finder to version 3.0
  • ADDED: Microsoft Excel Task Pane like interface.
    • ALTERED: Minor improvements in the user interface.
• Updated: Random Generator to version 1.2

Version 1.2 (25-Apr-2007)

• Updated: Duplicate Remover to version 1.3
  • ADDED: AbleBits.com menu is added to the Excel main menu.
    • ADDED: Checking if Autofilter is applied to the table data.
    • ADDED: Increased speed in the "Compare two ranges" mode.
    • FIXED: "Data series method of range class failed" error in filtered tables.
    • FIXED: Error related to the lack of free columns in the worksheet.
• Updated: Merge Tables Wizard to version 1.2
  • ADDED: AbleBits.com menu is added to the Excel main menu.
    • ADDED: Ability to process filtered rows on in Table 1.
    • ADDED: Checking if Autofilter is applied to Table 2 data.
    • FIXED: "Data series method of range class failed" error in filtered tables.
    • FIXED: Error related to the lack of free columns in the worksheet.
    • ADDED: Increased speed in the "Compare two ranges" mode.
    • FIXED: Error in adding a column to Table 1 or updating data, blank cells from Table 2 displayed "0" in Table 1.

Version 1.1 (16-Mar-2007)

• ADDED: Compatibility with Microsoft Windows Vista.
• ADDED: Compatibility with Microsoft Excel 2007.
• ADDED: Merge Tables Wizard for Microsoft Excel 1.0.
• UPDATED: Duplicate Remover to version 1.2
  • FIXED: Incorrect work with an outlined range in "Search single range" and "Compare two ranges" modes.
  • ADDED: "Reset used range" command is executed after the search is complete.
  • ADDED: Excel Find settings are reset to default after the search is complete.
  • FIXED: Processing of a single-row and a single-cell range used as a Second Range in the "Compare two ranges" mode.
    • ALTERED: Table header auto detection algorithm was improved.
    • FIXED: Minor bugs when working with Excel 2007.
  • UPDATED: Explorer for Excel to version 2.0
  • UPDATED: Advanced Find & Replace to version 3.0
    • ADDED: Microsoft Excel Task Pane like interface.
    • FIXED: It was impossible to type some special symbols in the "Find what" field.
    • FIXED: Switching between keyboard layouts.
    • FIXED: Opening Excel Taskpane when Find & Replace pane is open.
    • FIXED: Increased speed of hyperlink search.
    • FIXED: Some minor bugs in user interface.

Version 1.0 (20-Feb-2007)

• Ablebits.com Add-ins Collection for Microsoft Excel 1.0 is released.

 

 

 

Contact us

 

 

Your Name*
Your e-mail*
Subject
Message*
	Please remember that we work from 9am to 6pm GMT this is 5:00am - 2:00pm EST, 2:00am - 11:00am PST and our public holidays may differ from yours.