Apparity’s Integrity Check tool identifies potential spreadsheet errors, so that the file can be updated and its integrity restored.

Squash Speadsheet Errors

Easy to Use

The user opens an Excel file to be analyzed and selects the Integrity Check icon on the Apparity ribbon to initiate the integrity audit. This feature can even be used on end-user files not being monitored by the Apparity EUC Management Platform.

Spreadsheet Integrity Check - Excel Ribbon
Spreadsheet Integrity Check - Reviewing Error Results

The tool provides users with insight into spreadsheet errors by analyzing each cell, identifying errors and ranking those errors as Information, Warning or Severe. Some errors that Apparity will search for are formula errors such as #REF, #VALUE and hardcoded values within formulas.

Result outputs are visualized through graphs illustrating the error percentage associated with the entire workbook, as well as each worksheet. A user can group error values, sheet names, cell names and error description fields to better understand relationships and to analyze the results effectively.

Spreadsheet Integrity Check - Integrity Visualization Graphs

See Integrity Check in Action

Schedule a demo to see this and other great features of the Apparity platform in action.

Apparity Demo

Want to learn more? Contact Us