Let's Talk about .. Excel 2007-Synchronizing Tables with MOSS Lists

If you've ever used Excel 2003, you can connect to MOSS, both to read and write the list. But for Excel 2007 you may found that it can not do it directly. One of the methods is to do via Access 2007. I think because Microsoft recommended to use Access as the platform to connect to SharePoint. So you can transfer your Excel table to Access first, then use Access to update the list of SharePoint.

Anyway, there is the add-in from Microsoft to make your Excel 2007 be able to synchronize with MOSS. You can download the add-in from Microsoft at this link.

http://www.microsoft.com/downloads/details.aspx?familyid=25836e52-1892-4e17-ac08-5df13cfc5295&displaylang=en

The instruction to Add-in:-

1. Go to Excel Options.
   
2. Add-Ins-> Go.
   
3. In the Add-Ins window, click Browse.
   
4. Select your add-in.
5. Click OK.

After you added in, the new Publish button appears in menu of Excel 2007. Then, you can synchronize your table.