Spreadsheet Auditor

Image of Auditor Ribbon Bar

Spreadsheet Auditor provides version control and powerful auditing features to Microsoft Excel 2010.

  • Save time reviewing a model by quickly identifying what cells have changed, the dependents of those cells, and exceptions;
  • Backups happen automatically so you don’t have to worry about incrementing file versions;
  • Same tools can be used to compare any file to any other file;
  • Getting an overview of a model in minutes rather than digging through formulas for hours;

Spreadsheet Auditor is an Add-in to Excel 2010 that performs these functions:

  • Automatically maintains backups
    • Defaults can be set for all files so no further action is required;
    • Individual files can override default setting to backup more or less frequently;
    • Backups are created automatically in special situations: when a different user saves a file or the file is modified without Spreadsheet Auditor;
  • Overview provides the audit tools:
    • Changes to formulas and constants, whether in a cell or a range name;
    • Indicators for cell contents such as constants, errors, external file references;
    • Matching formulas and exceptions are highlighted;
    • Multiple levels of precedents and dependents, also including range names;

Version 1.0 of Spreadsheet Auditor is now available, compatible with Microsoft Excel 2010.  If you would like further information please do not hesitate to contact us.

Video Tutorial

Watch this video introduction see how Spreadsheet Auditor can help you!