With Version History you can travel back in time to historical versions of your workbooks. Every worksheet change, down to the individual cell level, is automatically captured and stored in a backed-up version that is quickly accessible for reviewing and restoring from as needed. The sheet-time continuum is now in your hands!
Topics in this Article
- Version History
- Version History Menu Options
- Connectivity loss detection and recovery
To access a worksheet's version history, open the desired workbook and select the version history button in the top right.
From here, you can see all past versions of this workbook, who edited them, when, some of the changes they made, and more.
Clicking on any one version will update the version history viewer, allowing you to see the previous worksheet and the changes that were made compared to the version that came right before it. For instance, in the screenshot below, we can see that Aaron changed the URLs in our bug tracker (he accidentally deleted a few).
But it's okay that he deleted some data, we can restore it. To restore your worksheet to a previous version, select the desired version, and select "Restore this version" either via the button at the bottom-left , or through the version menu next to the version's name:
Before you replace, Spreadsheet.com creates a backup of the current version that you can also restore back to.
Version history menu options
Inside the Version history menu are a number of unique options to help navigate and restore lost data.
In the top right corner of the Version History menu, you have the option to highlight changes (or not). Highlighting changes makes it easier to see exactly what is different across versions.
Note: Version history highlights changes from one version to the most recent past version, not from the current version to any desired past version.
Copy and paste from previous versions
Sometimes you don't want to restore a past version as the new version, but you do want the data from that version. In these cases, you can try copying and pasting from a past version into your existing workbook or a new workbook.
Create a new named version
With the + Named version button you can create a new version with the current state of the workbook and name it to make it easy to navigate to or recover later.
Name a past version
Similar to the + Named version button, you can rename a past version. Giving past versions names can help you remember what changed, who changed it, or why it changed, making it easier to recover later.
Back to workbook
When you're done reviewing versions and restoring (as needed), navigate back to the workbook and edit your version live.
Connectivity loss detection and recovery
Collaborating with other users in real time when connections are spotty can be tricky to manage. That’s why we’re excited to announce the release of connectivity loss detection and recovery in Spreadsheet.com. Now when your internet connection becomes unavailable you will see a notice at the top of your browser.
Spreadsheet.com will automatically reconnect and sync your workbook with the latest changes once your connection is restored.
This includes coverage for other common scenarios such as leaving a workbook open in a browser tab and coming back to it after a long period of inactivity (e.g. overnight or a weekend holiday). When returning to your workbook you will now see a “Syncing workbook …” message as the workbook is brought up to date with any changes made since you were last online.