Picked this up from Eli's blog:
In Excel 2003 you were able to sync amendments both from a Excel 2003 spreadsheet to a SharePoint List and from a SharePoint List to an Excel 2003 spreadsheet. But in Excel 2007 this is no longer the case...Well it was until Microsoft released an Excel 2007 Add-in.
This is a must install if you are upgrading to Office 2007 from Office 2003, otherwise your users will cry. The Excel 2007 Add-in, can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyID=25836e52-1892-4e17-ac08-5df13cfc5295&DisplayLang=en There is also an accompaning MSDN article "Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists": http://msdn2.microsoft.com/en-us/library/bb462636(office.11).aspx
Technorati tags: excel, sharepoint+2007, office+2007, office, sharepoint, moss+2007, moss, microsoft
The other option you have in 2007 is to use Access, which is extraordinarily good at taking lists offline. Much better than Excel. Just open you list in Access from the list's Actions menu. Changes in Access are seemlessly sync-ed to SharePoint. You can go offline, edit the lists to your hearts content, and next time online will all sync up again automatically.
ReplyDeleteThere is also a good article and a nice tool available here http://www.softfluent.com/article_excellist_en.aspx.
ReplyDeleteIt allows end uses to be able to click on WSS "export to spreadsheet"