Undo or Redo an Action

PowerPivot for Excel provides the ability to undo many actions that you perform in the PowerPivot window. However, some actions can't be undone. These actions include the following:

  • Saving a file

  • Creating or deleting a table

  • Deleting a column of data (However, you can undo the deletion of a calculated column)

  • Changing data types that might result in the loss of data precision, such as changing a column data type from Double to Integer, or changing from String or Integer to Boolean.

  • Refresh operations

  • Any operations on measures

Performing an operation that cannot be undone clears the undo and redo history; therefore, you lose the opportunity to undo any actions that happened before the preceding operation. If you perform an operation that is meant to remove data and the operation cannot be undone, PowerPivot will ask you to confirm the operation. You do not need to confirm any operations that can be undone, such as deleting a calculated column.

To undo an action

  • In the PowerPivot window, click the Design tab, and in the Edit group, click Undo.

-or-

  • Press CTRL+Z.

Note

If the last action cannot be undone, the Undo command is not available.

To redo an action that you undid

  • In the PowerPivot window, click the Design tab, and in the Edit group, click Redo.

-or-

  • Press CTRL+Y.

Note

If the last action cannot be redone, the Redo command is not available.

See Also

Other Resources

Working with Tables and Columns