|Compare Excel files
This feature allows you to compare Excel files or
to compare worksheets within the same file. It generates
a concise report of the differences in the formulae, input
values or results (see the figure below).
• It allows you to compare Excel workbooks
in a single operation. Spreadsheet Advantage generates
a workbook containing one comparison report sheet for each
pair of corresponding worksheets in the workbooks, thus providing
a compact record of the differences between
the workbooks. (Alternatively, you can choose to compare a
pair of individual worksheets. This can be useful when you
want to compare two similar sheets in the same workbook).
• Spreadsheet Advantage intelligently groups
adjacent cells containing the same formula when displaying
differences. For example, in the figure below the formula
in cells AC21:AR21 has changed. Spreadsheet Advantage reports
this as a single item, instead of listing every single cell
in the range. This dramatically shortens the list
of differences, making it much easier to see
the important changes.
• Spreadsheet Advantage highlights the differences
between formulae using bold, red text (as shown in
the figure below). This allows you to focus on the
actual changes, and is particularly useful when the
formulae are long or complicated.