G
Guest
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!
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!