Rainbow Analyst Spreadsheet Auditing Tool

Unzips the workbook file to delete passwords and remove protection from worksheets and the workbook.

Creates a visual map of the structure of a workbook showing the sheets and their interconnections.

Highlights blocks of copied formulas, so that omissions, hard-coded numbers, and inconsistent formulas are immediately visible.

Highlights blocks of copied formulas, and generates a report listing each unique formula for systematic spreadsheet audit.

Helps you track unresolved issues and collaborate with colleagues to correct errors.

Generates an interactive report of pivot, query and data tables and lets you edit the underlying pivot caches and data connections.

Interactive tool for tracing precedents and dependents, with a best-guess description of what each cell means.

Generates reports and colour maps showing potentially risky patterns, checks, formulas and hidden cells.

Unhides hidden sheets, rows and columns, unprotects protected sheets, and optionally clears cell colours.

Unzips the workbook file and lets you reset custom styles, list all external links, and delete names with phantom links. It was able to reduce the size of this severely corrupted workbook from 2.9 MB to 0.8 MB.

Compares worksheets, workbooks, or ranges within a worksheet or workbook, and also macros in different workbooks.