Set the Default Workbook State

Set a workbook state to be the default state when you open the workbook.

If you set the default state to Last State, the workbook opens in whichever state it was in when you last closed it.

The Undo Last Edit and Redo Last Edit options in the workbook toolbar don't affect any changes you make in the Manage States dialog.

  1. On the Home page, hover over a workbook, click Actions, then select Open.
  2. Click State Menu State Menu icon, then click Manage States.
  3. In the Manage States dialog, hover over the state you want to set as the default state and click the checkmark beside it.

  4. Click Done.