When you export a Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server (MOSS) list to Microsoft Office Excel 2007 the SharePoint list is converted to a table. It is not possible to maintain a read/write link with the SharePoint list.
Note: Existing Microsoft Office Excel 2003 workbooks can still be synchronized in a SharePoint linked list.
Begin by using the Export to Spreadsheet function on your SharePoint List. Open the .igy file, and enable the content. You will be looking for some XML contained in the Connection Properties under Command text. The XML will look something like this. Make sure you use the <VIEWGUID></VIEWGUID>.
Next you will need to create a macro. Run the macro once, and a correctly configured list that allows two way refresh with your SharePoint list will be created. Make sure the name of your list correctly entered between the source and the guid.
Reference: A SharePoint list is converted to a table, and synchronization of the SharePoint list is disabled after you save an Excel 2007 workbook
The code worked with me, the problem is that im trying to do a mass update, with a copy-past in more than 30 rows, but when i do this, the ID of the list get lost, and create new IDs (rows) to the list.
Anybody is getting this problem to? How do you work with mass update in SharePoint Lists?
In Fact, this problem occurred only in the ID 20. If i try to change any information in any other row, works fine now. I’ve already deleted ID 20, but sharepoint assume another line to the ID, and the problem stills