DiffEngineX LLC have released an advanced tool to find the differences between Excel workbooks. It generates both a conventional listing of differences and a report with the differences highlighted in color. It has many advanced options and is free to use for the first 30 days.
DiffEngineX is a utility that reports on the differences between the formulae, constants, names, commens and VBA macros contained in either two whole Excel workbooks or selected worksheets.
DiffEngineX has a conventional desktop user interface as well as the ability to be invoked from the Windows Command Prompt and from software via command-line arguments. It can be used as a plugin and invoked from source control systems. It is highly configurable and possesses a rich set of command line arguments.
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. Its difference algorithm is fast and scalable.
DiffEngineX was one of the first compare Excel workbook tools available that was both fast and reliable. At the time it was released DiffEngineX could do in 30 seconds what other tools took minutes to do.
Click here to find out more.