Very often you need to analyze spreadsheet, modify some cells or VBA code and give this file back with explanation – what you’ve changed in this Excel file.
For the Excel user this is common situation:
All differences found by xlCompare utility between two compared Excel files are listed in the Difference Explorer.
This window contains structured list of the differences, grouped by worksheet and by type of modification:
To get more information on how to compare to Excel files using xlCompare Diff Tool and get the difference explorer, visit this page:
xlCompare is a diff and merge tool for Excel files. Difference Report is one of the features, implemented in the application.
To get difference report, for compared Excel spreadsheets, use Difference Report button above this list.
Button opens Difference Report window. Here you can browse all differences combined into form of structured summary report.
This list is outlined to simplify navigation. Expand or collapse groups of report items.
Every edited formula or constant cell value appear in this list with highlighted difference. xlCompare reflects change in the cells value or text of the formula with highlighted colors. Red and Green letters indicate added or removed parts of the text.
This window is like a Print Preview. You see how Difference Report looks and how it will look for the person, who receives this file.
To transfer it to your colleague, use buttons on the left side of the report window:
Excel workbook is the best format to transfer difference report to other users.
In this example we’ve presented you Difference Report for a Compares Price Lists example, presented on the How it Works page.
For other workbooks, report is similar – with highlighted changes in formulas and values. Please look into this example for calculations spreadsheet. We’ve compared two worksheets with set of changed formulas.
Difference Report below clearly identifies changes made. In the form of XLSX file we’ve sent it to our customer.