Hi All How to synchronize excel with list,ie when ever i make changes to list it should reflect in the excel and whenever i change in excel it should reflect in sharepoint list as well.How can we achieve this. Do we need to create dataconnection library for this,or we can get it done by just exporting the list in spreadsheet. I tried exporting to spreadsheet.But when i change it in the excel,the new values are not getting updated,But when i make changes to the list,it is getting reflected in the excel.I tried this in Excel 2007.I just wanted to know the solution for excel 2003 as well as 2007.Please advice.ThanksKarthik S

Here you go: "Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists" http://www.microsoft.com/downloads/details.aspx?FamilyID=25836e52-1892-4e17-ac08-5df13cfc5295&displaylang=en Laura Rogers, MCSE, MCTS SharePoint911: SharePoint Consulting Blog: http://www.sharepoint911.com/blogs/laura Twitter: WonderLaura