A couple of days ago, I demonstrated to a group of customers the ability to synchronize Excel 2010 with SharePoint 2010.
In order to synchronize Excel data with SharePoint, you need to convert a range of data into a table. The moment you create the table, Excel will show you an extra button to “Publish and allow Sync” to SharePoint (see screenshot).
In the following days I received several e-mails asking where that $%^$^$@$!@ button was.
I then vaguely remembered I installed an Excel 2007 add-in (about two years ago…) to allow synchronizing with SharePoint 2010. Somehow Microsoft obviously forgot to have this functionality by default in Excel 2010. Unbelievable btw…
So, if you want to synchronize Excel 2010 with SharePoint 2010, you need to install this Excel 2007 add-in.
After extracting the SynchronizeWSSandExcel.xlam file, you need to configure the add-in through File > Options > Add-Ins.