Synchronize Excel 2010 with SharePoint 2010 List

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.

Have fun!

 

 

7 thoughts on “Synchronize Excel 2010 with SharePoint 2010 List

  1. russell

    Hey, I’m trying to use that addin. I create the table, then click publish and synch. I enter my site name and the list name. It crrates the list and loads it to sharepoint. When I add a new Item in sharepoint , it ddoes not come back down to Excel.
    Any Ideas,?

    Reply
    1. Ernst Wolthaus Post author

      Hi Russel, did you refresh the table in Excel? The data in Excel won’t refresh by itself, you need to refresh the data in the table.

      Reply
  2. Anuhya

    Hi,

    i already have a list on share point and i have exported it into excel, it does not show synchronize list, any ideas how to get this sorted?

    Thanks

    Reply
  3. Pingback: Synchronize Excel Data With SharePoint List | The SharePoint Effect

  4. Mahendran

    Hi,

    when i add a new item in Excel it doesnot update into the sharepoint lint,but when i add new item in sharepoint list it is reflect in Excel sheet,could you please suggestion to get the solution

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *