Sometimes you accidentally create an unnecessary workbook, or simply want to remove an old and unused one. For these and other cases, if you are an owner, then you have the option to delete a workbook. But be careful. Before you delete, make sure you do not need any of the data or contents of that workbook. Deleted workbooks are currently not recoverable, will be deleted for all collaborators, and removes related row relationships.
How do you delete a Workbook?
There are two ways to delete workbooks. Only users with the Owner permission level can delete a workbook, but if that's you, then you can either delete 1) from a workspace or 2) from inside the workbook to be deleted.
1) From a Workspace
While on the Spreadsheet.com Home page, navigate to the workspace and workbook you want to delete. Right-click on the workbook or click on the arrow to the right of the workbook and select Delete from the options.
After selecting Delete, a warning will pop-up to double-check you want to delete. As you will not be able to recover workbooks after they have been deleted.
Once you are certain, click Delete to delete the workbook.
2) From inside the workbook
You can also open a workbook you may want to delete to verify, and delete from inside the workbook. To delete the workbook, click on File and then select Delete.
Like the previous delete process, selecting Delete will open up a warning as deleted workbooks cannot be recovered.
What happens to related rows if you delete the worksheet that they're called from?
Deleting a workbook also removes any related rows in other worksheets. All related rows and related row lookups will be removed and stop working. Make sure you remove and store any data you will need before you delete a workbook.
For instance, the image below shows a related column now empty, and with an error in both the column header and data type dialog box.