When you users edit a value in a worksheet, the action is recorded in the cell history. All workbook users can view the history of any cell, at any time. If the cell is in a row to which you are assigned, you can restore any of the historical cell entries, both formulas and values.
The ability to view an audit trail in the worksheet is useful for all budget contributors but particularly important to budget owners. It might be as simple as finding that a value that was entered in error and wanting to go back to see the original amount, or something more significant, such as investigating the cause of an anomaly.
Right-click a cell and click Cell History. A window displays with details about the changes that were made to the cell, including amounts, whether a formula was involved, the user’s initials and when the change was made.
The Cell History window displays the following items for each cell entry:
The time when the change was made.
The initials of the user who made the change.
The value that was entered into the cell and an fx indicator, if it was calculated by a formula.
A Restore entry button (if you are assigned to that row).
| Info |
|---|
You can also view the workflow history. |
Related pages