Spreadspeed Auditor Feature Tour
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.
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
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.
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.
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.