Apparity’s Integrity Check feature gives users the capability to identify potential spreadsheet errors so that the file can be updated and its integrity restored. A user opens the file to be analyzed and selects the Integrity Check icon on the Apparity ribbon to initiate the functionality. The feature can even be used on files not managed by Apparity.
The Integrity Check 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.
Apparity’s Integrity Check 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 Integrity Check results effectively.