Excel Audit Reports

Spreadspeed Auditor includes a number of auditing reports to help you document and analyze the content of your workbooks. The reports can be generated via the Spreadspeed ribbon and are output to a new worksheet in the active workbook. This page contains a complete listing of the available reports.

Worksheet Comparison Report

This is a companion report for the Compare Worksheets auditing tool. Given two user-specified worksheets, the generated report will list all the cells with formula, value, number format, date format, and style differences. Like all the other reports listed on this page, it will also contain a link to the cell in question on the audit worksheet.

Worksheet Comparison Report Screenshot

The image below shows an abbreviated version of a worksheet comparison report.

Worksheet Comparison Report

Master Audit Report

The Master Audit Report is a compilation of all the individual reports listed below. The individual reports are generated directly from the Spreadspeed ribbon, whereas the Master Audit Report prompts you to choose which reports to include. It also provides customization options for some of the reports, as shown in the image below.

Master Audit Report Dialog

Master Audit Report

Formulas Report

Generates a complete list of all the formulas in each worksheet.

External Formula References Report

Generates a list of all the formulas in each worksheet that reference cells in other sheets or other workbooks.

Cell Errors Report

Generates a list of all the cells in each worksheet that have Excel Error Checking options flags.

Circular References Report

Generates a list of all the cells in each worksheet that have circular references. Excel has a built-in tool to identify circular references, but if a worksheet contains more than one circular reference, the Excel Error Checking > Circular References tool often shows only the first one.

Comments Report

Creates a listing of all the comments in the workbook, including the parent worksheet name, the address of the cell containing the comment, the value of the cell, the cell formula (if applicable), and the text of the comment itself.

Hyperlinks Report

Creates a listing of all the hyperlinks in the workbook, including the parent worksheet name, the address of the cell containing the hyperlinks, and the hyperlink target (range, file, URL, or email address).

Named Ranges Report

Creates a listing of all the Named Ranges in the workbook, including its parent (worksheet or workbook), what the name refers to, whether the name has errors, and if the name is hidden or visible.