Wednesday, May 13, 2009

Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists

Excel 2003 had a feature that allowed you to synchronize with a SharePoint list. For some odd reason it was left out of Excel 2007. Lauren Clear, Lauren, a co-worker, happened to come across the following add-in for Excel. It allows you to publish an Excel spreadsheet to SharePoint and synchronize the changes.
http://msdn.microsoft.com/en-us/library/bb462636(office.11).aspx

Figure 1 Image of "Publish and allow Sync" button on the Design tab


I'm interested in your experiences with this add-on, feel free to comment.
Thank you Lauren.

No comments:

Post a Comment