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 ...
Get Microsoft® Windows® SharePoint® Services 3.0 Step by Step 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.
