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

Download (1737 KB) Website Link to this page