Chapter 6. Understanding the Datasheet and Explorer Views

Lists and document libraries are fundamental building blocks for almost every SharePoint site. Unfortunately, the default view is fairly simple and has limited functionality with regards to adding, updating, deleting, or organizing data. SharePoint provides two views that create an alternate interface for examining your structured data. This chapter demonstrates some of the powerful features associated with each.

If you aren’t familiar with lists, you might want to skip ahead to Chapter 14 to read more about the various types and features of lists.

Datasheet View

The Datasheet view (Figure 6-1) displays data from a list or document library in grid format, similar to that of Microsoft Excel. The advantage of a datasheet is that the Excel-like interface provides the same easy methods of inserting, editing, and deleting data but still uses the data validation that is part of a list or document library.

The features of the Datasheet view depend on which version of Microsoft Office is currently installed on the machine accessing the SharePoint site.

A Datasheet view is automatically created with each new list or document library. Additional Datasheet views can be created in compatible lists or document libraries by using the Create View menu option available from the Settings toolbar menu option.

In this chapter, we focus on the following aspects of the Datasheet view:

  • What’s new for the Datasheet view

  • System requirements and browser ...

Get SharePoint 2007: The Definitive Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.