1. Modeling
  2. Working with Data
  3. Undo Data Entry
  4. Undo an Operation

You can Undo data entry from:

  • the keyboard shortcut Ctrl-Z (for Windows) or Cmd-Z (for Mac)
  • the Edit menu in the module toolbar:
  • a button on the module toolbar:
  • a button on the dashboard toolbar:

You can undo the most recent change you made to a data value in Anaplan. When you undo your most recent data value change, a message displays the old and new value:

Undo data entry across multiple tabs

If you have more than one dashboard or module open, you must be in the tab containing the most recent data change to be able to undo. For example, if you make a data entry change on dashboard A, and then open dashboard B, the change on dashboard A cannot be undone until you move focus back to dashboard A.

Anaplan holds the three most recently viewed dashboards and the three most recently viewed modules in memory. If you cycle through four or more open elements—either four dashboards or four modules—Anaplan will refresh the data in the oldest tab. If your last data change was on the refreshed tab, you won't be able to undo that change.

Undo data entry with multiple users on the same grid

If two users enter data into the same cell in a grid sequentially, the first user will not be able to undo their data change, because their grid no longer displays the most recent data value. Refreshing the first user’s grid will display the most recent value.

Preview reverted values

If a user attempts to undo an operation that changed the data values in more than one cell, a dialog displays an abbreviated preview of the data change. Operations that can change the data values in up to 10,000 cells, such as paste, copy across, or copy down, can be reverted using Undo data entry.

A similar preview is displayed if a user scrolls the dashboard or module grid so the most recently edited cell and value are no longer visible. If the user scrolls the value out of view and then selects Undo data entry, a confirmation dialog displays the value to be reinstated.

Undo data entry will not revert to the previous value when:

  • you have not made any changes—a message displays No changes to undo.
  • you try to undo more than the most recent value edit—if you make two undo attempts in sequence, a message displays No changes to undo.
  • the data grid is changed after a data value is edited, such as a filter is applied, or the data is pivoted or hidden—a message displays Grid definition changed can't undo last update.
  • a large import or complex formula is being processed—a message displays Processing ... (you can undo once processing is complete).

Undo multiple updates

Each change to a data value in a grid is an operation; a collection of operations is a submission. If you change the values in multiple cells and they have a green background after editing, this indicates the server is busy: these changes can be sent as a single submission when the server becomes available. If a user attempts to undo after a multi-operation submission, a message may display Multiple updates were submitted in one batch - can’t undo, depending on how many operations were sent in the submission.

Undo data entry can only undo the most recent data value change: this message is displayed when it’s not possible to identify which operation in a submission the Undo data entry request refers to.

Undo data entry when using numbered lists

When reverting the value of a cell in a line item formatted to a numbered list, the undo message will display the unique identifier for the item, not the display name (except when there are duplicate values in Lists and Roll-ups > General Lists > Display Name Property).

Undo data entry can only revert values when there is a one-to-one relationship between the unique identifier and the display name. If the same display name value appears more than once in the numbered list, undo cannot identify the value it should revert to: attempting Undo data entry back to a duplicate display name value will return a blank value to the cell.

For example, two items in a numbered list have the Display Name Property value: Robert Smith.

Suppose the grid cell initially displays one of the duplicate Robert Smith values, then the cell is edited to select any other value, for example James Jones. If you attempt to undo the data edit, a message displays showing an empty reverted value.

The grid is updated with a blank value, because the replacement value is not unique in the list of display names.

Undo data entry with a breakback calculation

If a user selects Undo data entry after amending a Breakback total, it will revert to the previous value and Breakback will be re-calculated.

If you apply Breakback and then edit one of the distributed Breakback values beforeyou attempt Undo data entry, the edited value will be reverted, not the breakback total value.