As you know, Access 2007 is a recommended platform to update  data and information to SharePoint lists and using lists offline. But a lot of end users don’t familiar with Access so it will better if they can work with  Excel instead.

Actually, publishing and synchronizing Excel worksheet to SharePoint list is not a new features. Since mid of 2007, Microsoft allow you to publish and synchronize between  Microsoft Excel 2007 and MOSS2007/WSS3.0 with an Add-In for MS Excel 2007. I tested again and it works well on MS Excel 2010 and SharePoint Server 2010.

In this post, I would like introduce about this Add-in and tell you how to enable in Excel 2010 and work with SP 2010

1. Firsly, you can download this Add-In here: Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists

Run XL2007SynchronizeWSSandExcel.exe and follow the instruction to complete the installation. In this progress, remember where you extract the xlam Add-ins file.

2. Start Microsoft Office Excel 2010, from the File menu, select Options, you will see Add-Ins tab as below

– From the Manage combobox, select Excel Add-ins and click Go

– Browse and select xlam file, then check on Synchronizewssandexcel, click OK to enable this Add-in

3. Create Table data with some information (reate table) and save it with Excel 93-2007 workbook

4. A new Design tab will appear with Publish and allow Sync ribbon button

5. Click on this button and fill SharePoint server information as below

6. Click on Publish button to publish data to Customer Review SharePoint list. From now on, you can change the data from this workbook and sync to SharePoint list and vice versa.

Hoang Nhut Nguyen
Email: nhutcmos@gmail.com
Skype: hoangnhut.nguyen