Apparity’s Integrity Check tool identifies potential spreadsheet errors, so that the file can be updated and its integrity restored.
Squash Speadsheet Errors with Ease
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 Platform.
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 hard-coded 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.