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 an Excel 2007 Table to a SharePoint Site

Creating a SharePoint list from within Excel 2007 is known as exporting an Excel table. In Excel 2003, this was known as publishing an Excel list. Once the table data is placed on the SharePoint site, users can see the Excel 2007 data without opening Excel 2007. As in the first exercise of this chapter, you can maintain a link between the SharePoint list and the Excel 2007 data, but any changes in the Excel 2007 spreadsheet are not reflected in the SharePoint list. You can only synchronize changes in the SharePoint list to the Excel 2007 spreadsheet.

In the following exercise, you will export a spreadsheet to a SharePoint list by using Excel 2007 and a two-step wizard.

Note

BE SURE TO start Excel ...

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