Home > Not CodeFluent Related :), SharePoint > Using Office Applications As Clients

Using Office Applications As Clients

Using CodeFluent Entities you can generate synchronizable lists which lets you use Office Excel (2003 and upper) and Office Access (2007 and upper) as front-end clients of your application. This feature is actually discussed in this post: Introduction to SharePoint Lists.

However, in Excel 2007 and 2010, the ability to update SharePoint lists changed in the following ways:

  • Opening a list from SharePoint with Excel 2007 or 2010 disables the "Synchronize with SharePoint" feature.
  • Existing .XLS files from Excel 2003 still load and continue to support update functionality when opened in Excel 2007 or 2010.
  • Lists that link to a SharePoint site are converted to read-only tables when you save existing files to the new Open XML Excel 2007 or 2010 file formats.

This means that the synchronization functionality still works and is still assured by Excel, however Excel 2007 and 2010 can not access it when exporting from SharePoint.

To address this issue we released a tool named the SharePoint List Synchronizer.

It opens Excel in compatibility mode since the synch feature is still available in this mode, and loads the list. Once this is done, our tool is out of the equation, it’s fully transparent and restores the same experience as in Excel 2003.

If interested, more information on the tool is also available on CodeProject as well: Restoring Two-Way Synchronization on SharePoint Lists Using Excel.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s