SharePoint List Synchronizer For Microsoft Excel allows Excel users to open SharePoint Lists in two-way sync.
SharePoint List Synchronizer For Microsoft Excel 2007 and 2010 adds two-way sync support for SharePoint Lists. This powerful feature used to work directly in Microsoft Office Excel 2003 but the update ability was deprecated in Excel 2007 and Excel 2010. SharePoint List Synchronizer for Excel re-enables this functionality so now you can export your list to Excel 2007 and 2010, and synchronize back to SharePoint without any extra-effort.
In Microsoft Office Excel 2003, you can connect to (read from) and update (write to) lists that reside on SharePoint sites. This allows you to keep the information in your Excel 2003 tables synchronized with the information that appears on the SharePoint site. In Microsoft Office Excel 2007 and Microsoft Office Excel 2010, the ability to update the information in SharePoint lists from Excel is deprecated. Instead, Microsoft Office Access is the recommended platform for writing data to SharePoint lists and for using lists offline. However, the SharePoint List Synchronizer for Excel 2007 and 2010 addresses this issue and allows Excel users to open SharePoint Lists in two-way sync.
In Office Excel 2007 and 2010, the ability to update SharePoint lists changed in the following ways:
Microsoft published an add-in which allows users to publish new read-write lists in SharePoint (Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists). While this add-in works great to publish new Excel tables to SharePoint, it does not address the issue of lists exported from SharePoint. For example, every time you export your SharePoint list to Excel 2007 and 2010; all changes applied in Excel cannot be synchronized back with the original list anymore, instead you need to apply those changes manually or use Microsoft Office Access. The "Synchronize with SharePoint" menu has disappeared.
Thanks to the SharePoint List Synchronizer for Excel 2007 and 2010, this scenario is now possible in Excel again: you can export your list to Excel 2007 and 2010, and synchronize back to SharePoint without any extra-effort.
SoftFluent is a privately-owned company delivering software and services in software development. It is SoftFluent’s contention that software development is as yet too much of a mere craft. SoftFluent’s ambition – which it already has strongly implemented – vies to speed up its industrialization. SoftFluent, with its massive investment in Research and Development, capitalizes on CodeFluent Entities, software it designed to evolve according to the ever-changing prerequisites of your needs. In accordance with the pragmatic model-oriented approach of its product, SoftFluent extends the methods of software development to bring you the agility you need. SoftFluent only relies on high value people, who are expert partners deeply committed to your success.
Published in Development Tool News & Software Component News, December 09, 2010