Visual Content Type Audit | Audit Reports | Formula Tools (next)
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.
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 ScreenshotThe image below shows an abbreviated version of a worksheet comparison 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 DialogGenerates a complete list of all the formulas in each worksheet.
Generates a list of all the formulas in each worksheet that reference cells in other sheets or other workbooks.
Generates a list of all the cells in each worksheet that have Excel Error Checking options flags.
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).
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.
Visual Content Type Audit | Audit Reports | Formula Tools (next)