DiffEngineX is a utility that finds the differences between the formulae, constants, defined Excel names and cell comments contained in either two Excel workbooks or selected sheets.
It generates a cell by cell difference report in a new workbook and color highlights different cells in automatically made copies of your workbooks.
As Excel spreadsheets get modified over time new rows and columns can be inserted between existing ones. DiffEngineX can align both similar rows and columns in the sheets being compared. It has many powerful features such as the ability to hide matching rows, group like changes to adjacent cells and highlight differences at the character level. It can be used from its user interface or programmatically using command-line arguments.
DiffEngineX has many uses. It can be used to compare databases and comma separated value (CSV) files once they have been imported into Excel. It can also be used for what-if analysis. Simply create a copy of your Excel workbook, change the values of various inputs and compare it with the original. The affected calculations will be revealed. Note that the option to compare formulae using Their Calculated Values must be turned on first.
Click here to find out more.