MOSS Learning Resources

"Start page" for anyone interested in developing applications on the SharePoint platform: http://www.microsoft.com/click/SharePointDeveloper/

SharePoint Training Tutorials: http://www.fpweb.net/sharepoint-hosting/free-sharepoint-tutorials.asp

Video demos and training for Office SharePoint Server 2007: http://technet.microsoft.com/en-us/library/cc262880.aspx

Online SharePoint Server 2007 Courses: http://office.microsoft.com/en-us/training/CR102146081033.aspx

Microsoft eLearning Site: https://www.microsoftelearning.com/ (search for SharePoint on the site; there is tons of content)

Get SharePoint training on your desktop: http://office.microsoft.com/en-us/sharepointserver/HA102488011033.aspx

Get SharePoint Designer training on your desktop: http://office.microsoft.com/en-us/sharepointdesigner/HA102632321033.aspx?pid=CL100796271033

Technical diagrams and other supplemental documentation: http://technet.microsoft.com/en-us/library/cc263199.aspx

Downloadable content for Office SharePoint Server 2007: http://technet.microsoft.com/en-us/library/cc262788.aspx

Downloadable book: Installation guide for Office SharePoint Server 2007: http://technet.microsoft.com/en-us/library/cc298924.aspx

Downloadable book: Design and build sites for Office SharePoint Server 2007: http://technet.microsoft.com/en-us/library/cc298650.aspx

Downloadable book: Governance guide for Office SharePoint Server: http://technet.microsoft.com/en-us/library/cc718727.aspx

White papers for Office SharePoint Server 2007: http://technet.microsoft.com/en-us/library/cc262733.aspx

Advanced lectures and white papers: http://technet.microsoft.com/en-us/library/cc299032.aspx

Links to on-demand Webcasts: http://www.sharepointblogs.com/uday/archive/2007/04/08/webcasts-for-moss-2007.aspx

SharePoint Server 2007 Help and How-to: http://office.microsoft.com/en-us/sharepointserver/CH100305511033.aspx

SharePoint Server TechCenter on TechNet: http://technet.microsoft.com/en-us/office/sharepointserver/default.aspx

SharePoint Server 2007 Developer Portal on MSDN: http://msdn.microsoft.com/en-us/office/aa905503.aspx

Microsoft SharePoint Team Blog: http://blogs.msdn.com/sharepoint/default.aspx

Best Practices Resource Center for SharePoint Server 2007: http://technet.microsoft.com/en-us/office/sharepointserver/bb736746.aspx

More Free SharePoint online training resources : http://spforsquirrels.blogspot.com/2008/05/free-sharepoint-online-training.html

Two-way sync between Excel and SharePoint List

I was asked recently by a client why he was not able to sync the changes made to an excel sheet back to SharePoint. He had exported the SharePoint list to an excel sheet and expected that the changes made to the excel sheet would be propagated back to the SharePoint list.

Even though the capability existed in Excel 2003 to keep the information synchronized with a SharePoint list, with Excel 2007 this no longer worked.

As I started looking around, I found an Excel 2007 Add-in by Jon Adams that allows you to publish a read-write list to SharePoint. You can download the add-in here.

I was able to install this add-in successfully within minutes and the synchronization works like a charm. Once you publish the excel sheet to SharePoint, you can right-click the sheet and from the context menu, select "Synchronize with SharePoint". Steps to install and configure are detailed in the msdn article.

I also found a blog entry by Omar Shahine which led me to a "Excel 2007 Tables synchronizer" ActiveX control by Soft Fluent. (I haven't tested this yet but it looks promising.)