Audit Cell Change History in SecureSheet
SecureSheet tracks every change made by a SecureSheet user in every cell. Cell History is maintained with a SecureSheet forever, unless it is overwritten. Cell History is wiped clean when:
- An administrator purposely clears cell history.
- The row count or row order is changed on an import from Excel (or rows are reset for a SecureSheet online).
- To maintain cell history in an existing SecureSheet, you can re-import values and/or formulas, but you cannot change the row count nor the row order.
- For example, if the SecureSheet tab has 100 rows and your Excel file has 130 rows, and you import values and formulas, your cell history will be removed.
- If you would like cell history to be tied to the unique ID in Column A, contact the SecureSheet support team for assistance.
- Anytime a copy of a SecureSheet is made.
Audit Cell Change History
- The cell change history can be seen when the Cell Change History property is turned on in a View.
- When Cell Change History is on, an H will appear in every cell with a value that has been changed from its starting value.
- When you click on the H in a cell, another browser window will open with the cell change history.
- You may also take an export of cell history using the SecureSheet import/export tool and click the Include Cell History checkbox on the export.
- You may also audit a specific cell change through the SecureSheet-specific audit tool.