View spreadsheet properties

View spreadsheet properties

How to view spreadsheet properties

To view spreadsheet properties, go to File > Spreadsheet Properties.



The following details will be listed in the properties:
  1. File name: The name of the spreadsheet. View and edit the file name directly from the panel.
  2. Location: The location of the spreadsheet in your WorkDrive account. Specifies the folder and subfolders within which the file is placed.
  3. Current Version: The version number of the spreadsheet. It is the latest number by default, and displays the respective version number on version revert.
  4. Time Created: The date and time when the spreadsheet was created.
  5. Modified by: Details on who made the last edit in the spreadsheet along with the date and time.
  6. Permalink: The link that directs to the current spreadsheet. It can be used to share the file with collaborators or to hyperlink it.
  7. Published: Details on the publish status of the spreadsheet. If not published yet, you can do so from the panel directly.
  8. Share access: The users the spreadsheet has been shared. View and edit permissions directly from the panel.


Usage details

The usage stats provide details on the number of cells, charts, formula used and more. This can be viewed for an entire spreadsheet or for sheet tabs.
  1. Sheets: Total number of sheets present in the spreadsheet. Includes hidden sheets as well.
  2. Cells with data: Total number of cells containing values (non-empty cells).
  3. Pivot Tables: Total number of pivot tables used in the spreadsheet or the selected sheet.
  4. Charts: Total number of charts used in the spreadsheet or the selected sheet.
  5. Formulas: Total number of cells containing formulas in the spreadsheet or the selected sheet.