DiffEngineX is a utility that reports on the differences between the formulae, constants, defined names and cell comments contained in either two whole Excel workbooks or selected worksheets. As Excel workbooks get modified over time new rows and columns can be inserted in between existing rows and columns. This can confuse a straightforward difference analysis where identical cells are only recognized as such if they have the same row and column numbers in both of the sheets being compared. DiffEngineX can align both similar rows and columns between the worksheets being compared by the insertion of blank rows and columns. As such this problem is avoided. Conventional reports listing each cell difference are difficult to understand given the lack of context. This is why there is an option to automatically create copies of the workbooks being compared and then modify them such that the differences are highlighted in color. Different colors are used to flag deletions, modifications and additions. The options available allow users a choice between comparing formulae directly or by their calculated values. For example if two cells containing =2*6 and =3*4 are compared directly they will reported as different. If they are compared by their calculated values they will be reported as identical. It is common in workbooks modeling certain financial scenarios to have blocks of tens to hundreds of equivalent formulae that only differ from their neighbors in terms of their inputs. The absolute coordinates of these inputs change from one cell to the next, but the relative coordinates do not. If a later version of such a workbook is compared to an earlier one, hundreds of changes can potentially be reported. This makes a difference report tedious to inspect. DiffEngineX has a powerful feature to group equivalent changes made to contiguous cells into just one reported change made to a range of cells. It can be used from its user interface or the command prompt.

• ExcelSuite 4.2.4.2
  ExcelSuite is an application that can process data across numerous Excel workbooks.
  
  1.Add up the same cell across worksheets
  Is there a way to add the same cell...

• Remove Duplicates from Excel 1.1.4
  Remove Duplicates from Excel is designed for searching and processing duplicated cells in Microsoft Excel tables

• FindReplaceExcel 2.15
  FindReplaceExcel is a find/replace utility to search Excel files for text, values and comments and replace the text inside cells automatically without opening workbooks . The program can search ranges in worksheets. Multiple drives and directories...

• FindReplaceExcel 1.0
  FindReplaceExcel is a find/replace utility to search Excel files for text, values and comments and replace the text inside cells automatically without opening workbooks

• Excel Compare 3.0
  Track differences and compare Microsoft Excel files and spreadsheets with Excel Compare. Did you ever have an Excel spreadsheet that was edited and updated by several people? Was it a headache to figure out the differences between the files, and insert just the most recent entries into the final spreadsheet? Excel Compare saves your time by...

• Compare Spreadsheets for Excel 1.1.7
  Compare Spreadsheets for Excel is a powerful and convenient tool for comparison of files in Microsoft Excel

• Insert Multiple Rows and Columns Between Data in Excel 3.1.2
  Insert Multiple Rows and Columns is a powerful and easy-to-use Microsoft Excel Add-In for inserting multiple blank rows and columns between each row and each column, or every x rows and every x columns in Excel. The software supports the...

• Excel Swap (Reverse) Rows & Columns Software 1.1
  Quickly swap selected rows or columns without having to copy and paste