Working In And Creating Datasheet Views

Applies To Version(s): 3, 3.5 & 3.7

Overview


This page tells you how to create a standard or datasheet view, how to work/edit in datasheet mode and how to export to spreadsheets.

Create a Standard or Datasheet View


  1. Follow the Getting Here instructions.
  2. Click on Standard View or Datasheet View on the Create View page.
  3. Modify the view settings.
  4. Click OK to save and finish.



Edit in Datasheet mode


Bulk-edit items using a datasheet format. A version of Microsoft Office 32-bit that includes Microsoft Access is required to use this feature.

  1. Open the list or library from the All Site Content page.

  2. Open the List Toolbar Actions menu or the Document Library Toolbar Actions menu.

  3. Select Edit in Datasheet.

  4. Click in a cell to edit an item.

  5. Click in a different cell to save your changes.

  6. Reopen the Actions menu and select Show in Standard View.


Export to Spreadsheet


Export data from a ShareVision list or library to an Microsoft Office Excel spreadsheet on your computer, where you can work with data offline. Microsoft Excel is required to use this feature.

  1. Open the list or library from the All Site Content page.

  2. Open the List Toolbar Actions menu or the Document Library Toolbar Actions menu.

  3. Select Export to Spreadsheet.

  4. Click Save to save the file on your computer or Open to view the exported file.

  5. Click Enable to allow the data connections.

  6. Follow the ShareVision login/password prompt and click Okay.