Home > Excel Business Solutions > Excel Productivity > Navigation and Auditing > Data Integrity Analysis Share

Data Integrity Analysis

Excel data integrity analysis for navigation and auditing

Excel Data Integrity Analysis

Rate this solution:
(2/5 from 4 votes)
The Data Integrity Analysis add-in for Excel is a very powerful tool for analyzing spreadsheet integrity within Microsoft Excel 97 software onwards.

Excel Data Integrity Analysis is most likely to be used for two main purposes:
1. To assist in checking a workbook for integrity and for errors in logic and content, and 2. To help a user understand and find their way around a workbook created by a different author.

The Excel Data Integrity Analysis add-in is essentially a tool that runs across worksheets and changes the appearance of each cell based on its contents. This allows you to see at a glance whether cells contain a formula, text, or a number, or result in an error (this default option can be switched off). So it is easy to understand how a worksheet is constructed, irrespective of the actual values displayed.

The Excel Data Integrity Analysis add-in consists of two basic tools:
  • A tool to analyze, and
  • A tool to reset.

You can clearly see which cell is a number and should be a formula since it is colored as the other numbers (yellow = text, blue = number, green = formula).

FACT: Users believe that there is only an 18% chance that their completed spreadsheets contain errors, but 86% actually did contain errors. [Panko R & Halverson R 1996 'Spreadsheets on Trial: A Survey of Research on Spreadsheet Risks'].

Try It  Get It

(Pricing is available on the next page)
(Updated on 2023-10-01)

Related Excel Solutions for Data Integrity Analysis

Data Manipulation ToolsData Management  Convert 2007 VersionConverting and Integrating

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.