Excel 2007 Add-in for Synchronizing Tables with SharePoint Lists – now available!

microsoft-office-system-log If you have worked with SharePoint, lists are one of the most important features.  Unfortunately, creating and editing lists through the Web UI is something of a pain in the arse.  Excel, on the other hand, can do  just about anything with tables (nee lists) short of washing dishes with them.  It is with great joy, then, that I see the following on the SharePoint Blog.

In Excel 2003, you can connect to (read from) and update (write to) lists that reside on SharePoint (WSS 2.0 or WSS 3.0) sites. This allows you to keep the information in your Excel 2003 tables synchronized with the information that appears on the SharePoint site.

In Excel 2007, the ability to update the information in SharePoint lists from Excel is deprecated. Instead, Access 2007 is the recommended platform for writing data to SharePoint lists and for using lists offline. Unfortunately, this upset many Excel 2003 users to the point of being unwilling to upgrade to Excel 2007.

Specifically, in Excel 2007, the ability to update SharePoint lists changed in the following ways:

  • Existing files from Excel 2003 load and continue to support update functionality when opened in Excel 2007.
  • Lists that link to a SharePoint site are converted to read-only tables when you save existing files to the new Open XML file formats.
  • It is still possible to publish a table to SharePoint lists; however, this is a one-time write operation to SharePoint.

The good news is that an Excel 2007 Add-in for Synchronizing Tables with SharePoint Lists has just been released by Microsoft! This add-in allows you to publish a read-write list to a SharePoint list. However, the trade-off is that that you cannot save the workbook in the new Office Open XML Formats. Instead, to retain the functionality, you need to save the workbook in the Excel 97-2003 (Biff8) file format.

For more information, go here.

Comments (7)

  1. Anonymous says:

    Ran into an interesting issue when trying to upload a spreadsheet from Excel 2007 into SharePoint 2007.

  2. yeed says:

    Beijing on June 10 morning news, according to Bloomberg survey report GTM Research and the American Solar Energy Industries Association released the first quarter of this year, US home solar power system capacity increase of 76% over last year, to 437
    megawatts (MW) ,Solar Batteries http://www.poweroak.net the nation’s new generating capacity, more than half of which is a photovoltaic power generation. The report shows that a quarter of the US solar power capacity by
    1.3 gigawatts (GW), the sixth consecutive quarterly increase of over 1 GW. The total annual installed capacity is expected to reach 7.9 GW, Solar Power Penerator
    http://www.poweroak.net , Solar Power Pack
    http://www.poweroak.net representing an increase of 27%.
    The report predicts that by 2016 solar power will meet the electricity needs of about 800 million households in the United States to offset 45 million metric tons of carbon emissions, equivalent to removing 10 million cars. energy storage system

  3. qa says:

    Call Prachi for 24/7 sexy Mumbai escorts direct to your room in 20 minutes or less. Pink Angels of Mumbai have girls who come from a range of backgrounds and include glamour, fashion and young students. They are all beautiful, elegant, sexy, warm, fresh,
    sweet, young and stunning. http://pinkangelsofmumbai.in


  4. da says:

    Doxy.in offers you the finest escort’s in Mumbai. Call 24 hrs Ms Nimita to find quality Mumbai escorts service like Airhostess, Models, College girls, Housewife, working girls, Russian and more.


  5. sa says:

    Call SARA: we provide High quality Escorts service in Mumbai city. Here you will get fantastic Escorts Girls like College girls, Models, Airhostess, Housewife, Russian, Mumbai call girls and independent call girls in Mumbai for full service.

  6. wa says:

    Call PIYA: Mumbai Escorts. If you wish to obtain escorts in Mumbai, Piya.biz is the place for you, your source for different type of College girls, Models, Airhostess, Housewife, Russian, Mumbai call girls and independent call girls in Mumbai.


  7. za says:

    Call ZUHI . We provide High quality Escorts service in Mumbai. Here you will get fantastic Escorts Girls, Service offering by our beautiful escorts models. 3/5/7 Star hotel and home 24 hrs service in all Mumbai.