31 enero 2007

Excel 2007 does not support synchronization with Sharepoint lists

There is a loose of functionality when you move from Excel 2003 to Excel 2007. The later can not synchronize with Sharepoint lists, as the predecessor could do. This behaviour is by design, as you can see en this Microsoft KB Article: http://support.microsoft.com/kb/930006/en-us. The workaround suggested is creating a macro and keeping the file to be synchronized in 2003 format.

2 comentarios:

Anónimo dijo...

Hi,

You can have that 2-ways sync functionality back if you install the small free activeX (200K, no dependency whatsoever on anything) available here: http://www.softfluent.com/wsslists.htm.

It reroutes .IQY files associations to itself, so when you click on WSS's "export to spreadsheet" links, it launches Excel 2007, and creates a 2 way sync WSS list (sorry, "table" as the feature has been renamed in the newly created workbook/sheet.

Simon.

Anónimo dijo...

One issue..using this now I am not able to inset rows to the datasheet.Any workaround ?

Shireesh