I have an excel 2007 workbook with many tables linked to sharepoint lists.
In all, there are over 30 data connections, each containing a separate query
which Excel dutifully embeds in the workbook (under the connections.xml file).

The trouble is, about 3 of the tables refresh from the wrong sharepoint
list. I can edit the query to fix it, and it works until I save and reload,
whereupon it reverts back to the previous query the next time I load the
file.

Stranger yet, I edited the connections.xml file directly in order to fix the
queries. Some of them worked, but others now point to the wrong sharepoint
lists. Comparison with the earlier connections.xml (before I edited it)
shows that the new connections.xml has indeed written the wrong list queries
into some of the connections upon saving. Is this a bug? Has anyone else
had this problem?

Thanks in advance!

This discusses deprecated features in XL2007.
One of the subjects is "Writeback to SharePoint"...
http://blogs.msdn.com/excel/archive/...24/718786.aspx
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Kevin Parkin"
<Kevin
wrote in message
I have an excel 2007 workbook with many tables linked to sharepoint lists.
In all, there are over 30 data connections, each containing a separate query
which Excel dutifully embeds in the workbook (under the connections.xml file).

The trouble is, about 3 of the tables refresh from the wrong sharepoint
list. I can edit the query to fix it, and it works until I save and reload,
whereupon it reverts back to the previous query the next time I load the
file.
Stranger yet, I edited the connections.xml file directly in order to fix the
queries. Some of them worked, but others now point to the wrong sharepoint
lists. Comparison with the earlier connections.xml (before I edited it)
shows that the new connections.xml has indeed written the wrong list queries
into some of the connections upon saving. Is this a bug? Has anyone else
had this problem?
Thanks in advance!