O'Reilly logo

Microsoft® Windows® SharePoint® Services 3.0 Step by Step by Penelope Coventry, Todd C. Bleeker, Bill English, Olga M. Londer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exporting a SharePoint List to an Excel 2007 Spreadsheet

You can export the contents of SharePoint lists, results of a survey, or document libraries to an Excel 2007 spreadsheet. The exported list or library is a Web query that stays updated with changes to the original list in your SharePoint site. The Excel 2007 spreadsheet maintains a connection to the SharePoint list and therefore becomes a linked object.

In this exercise, you will export a list from a SharePoint site to an Excel 2007 spreadsheet. You will add data to the spreadsheet and then synchronize the data in the spreadsheet with the contents of the list on the SharePoint site.

Note

OPEN the SharePoint site on which you have a list from which to export data to an Excel 2007 spreadsheet. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required