Two-way Sync with Excel 2007 and SharePoint 2007 requires this add-in

In Excel 2003 you could edit a SharePoint list using Excel.  For some reason, probably because they are trying to push users to use Access for this now, Microsoft dropped two-way sync support in Excel 2007.  This ability was listed as a deprecated in WSS 3.0.
I came across this blog post today, which had a link to an Add-In from Microsoft to add this support back in.

BUT the Microsoft plug-in sucks…

In the comments of this blog post I found this ActiveX control that has MUCH better support.  The above add-in really only lets you create an XLS and then post it to SharePoint.  Once this is done you can then edit it in Excel.  What it is lacking is the ability to edit an existing list that’s already in SharePoint in Excel and then sync the changes back up. 

This entry was posted in SharePoint and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s