Were you working in Spreadsheet.com when some data seemed to just vanish? Did you check with your users, and no one has touched the worksheet recently? Don't worry; there are many steps you can take to try and recover any lost data.
Check your View, Filters, Sorts, and Hiden Columns
In the toolbar are several features to hide and rearrange data. While these are great most of the time, sometimes they can hide data without us realizing it. For instance, in the screenshot below, we have a filter, sort, and hidden column and a worksheet that seems to have no data below the table header row!
Try these steps to restore your view:
- Make sure you are in the same view as you were before.
- Try removing any filters you have in place, or filter directly for the missing data.
- Remove your sorts or sort by the data that is missing.
- Check your hidden columns, possibly unhiding them to reveal any hidden data.
In the case of our screenshot above, removing filters reveals all the previously hidden rows.
Useful whenever something goes wrong, the undo feature can be accessed either by pressing the undo button on the toolbar, navigating to Edit > Undo in the toolbar, or via the keyboard shortcut Ctrl + Z. Each time you press Undo, Spreadsheet.com will go back one additional change. And, if you go too far, you can always press redo .
Be careful, however, as undo is associated with your session. Leaving a worksheet and going back to the worksheet will prevent you from undoing changes from before you left.
Load the worksheet in a new window
Sometimes data is still there, but your browser or recently cached data is not showing it. Without closing your worksheet, try opening the worksheet in a new browser and window. Leaving your window open also helps ensure you can undo any previous changes.
Lost the worksheet altogether?
If you left your worksheet and forgot the name of it or can't seem to find it again, try navigating to the Recent tab on your homepage:
The recent tab shows the worksheets you've most recently worked on, as well as the account and folder associated with the worksheet.
Can't access a worksheet?
Are you no longer able to access a worksheet you once changed? See an error message like the one below?
If so, you may no longer have permission to access that workbook. To regain access, contact an owner or manager of that workbook who can add you as a user.