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 ...

Get Microsoft® Office Excel® 2007 Inside Out 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.