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.
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.
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.
If the last action cannot be redone, the Redo command is not available.