Microsoft® Office Excel® 2007 Inside Out

Exporting Excel Tables to SharePoint

If you have access to a SharePoint site, you can distribute Excel tables by publishing them on the site. When you export an Excel table to the SharePoint site, you can share table data with other users who use the SharePoint site, letting site users update the SharePoint list by opening the list and editing the data. This is a useful strategy for tables that are updated frequently by a number of users, particularly if other users need read-only access to the table data.

You can create a connection from the SharePoint list to the Excel table, or separate the two, depending on whether you want to propagate changes made to the list to the Excel table. If you create a one-way connection to the data in the SharePoint ...