SharePoint List Synchronization with Excel
A question which is often asked is how you can synchronize a SharePoint list with Excel. The answer differs on what version of Excel you use. Excel 2003 with SharePoint 2007/2010 With Excel 2003 the synchronization works in both directions. This means that you can create a SharePoint list connect to Excel, make changes in Excel and write back to Excel. The single restriction is that you can't create new items in Excel but modify existing ones. Excel 2003 has a bug in which an alert pops up and says that the field is read-only, when you try to modify a field. There is a patch for this bug found here: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=952608 To synch the lists go to the list you want to synch and click on "Export to Excel" button in the ribbon. The list will be opened in Excel and automatically connected to the SharePoint list. Now you can make changes within the Excel sheet. To synch back click on "Data" >> "List...