A few months ago, Omar complained about a deprecated feature in Excel 2007...synchronizing SharePoint lists with an Excel table. One of our Excel SDETs, Jon Adams, recognized this problem also and wrote an add-in to work around the issue. I put Jon in touch with Omar and he was pleased with the add-in, but it hadn't been released to the public yet so neither he nor I could post it. Well, now it has...

Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists

Before you despair, Jon Adams created an Office Excel 2007 add-in, Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists, which adds a button to the Table Tools tab on the Office Fluent Ribbon. This add-in allows you to publish a read-write list to Windows SharePoint Services. Note that you cannot save the workbook in the new Office Open XML Formats. Instead, to retain the functionality, you need to save the workbook in the Excel 97-2003 (Biff8) file format.

~tod

tags: office+2007, sharepoint