Manage Workbook Versions
You can create a named version of a workbook to save a snapshot of accumulated changes up to
that point.
To create a named version, select and enter a name in the
Add Version to
Workbook
dialog.To view a list of created versions, open the Versions panel by selecting .
To revert a workbook to a particular named version, select , then click
Revert
on the version you want to
return to. Worksheets automatically creates a new named version with an incremented
version number at the top of the version list.You can't view a previous version of the workbook without reverting to that
version.
When you revert to a named version, tracking of your individual changes is reset;
that is, tracking of the 15 changes that you can undo starts again at zero after you
revert to a named version.
Workbook comments are independent of any versioning status: the user sees
in the Comments panel all comments entered for the workbook, regardless of the
version where the comment was added. Restoring to a previous version of the workbook
doesn't undo or change the Comments panel data.
We recommend creating a named version before doing any of these actions, which can't
be undone:
- Delete or insert sheet
- Change format
- Recalculate or Recalculate All
- Refresh live data
Note
: You can't use a named version to revert changes to entry areas.