http://192.168.2.20/blogs/doverton/archive/2007/07/13/how-to-connect-to-and-import-data-from-an-xml-web-service-into-excel-2007.aspxI have been wondering how to do this recently for one of my own projects and then the subject came up internally. A very unassuming Hovsep then wrote up the answer, so as a tip here it is - if you follow the link at the bottom you will see a step by stepenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://192.168.2.20/blogs/doverton/archive/2007/07/13/how-to-connect-to-and-import-data-from-an-xml-web-service-into-excel-2007.aspx#23947Wed, 05 Oct 2011 12:45:56 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:23947Kristian<p>GeoNames have some nice demo XML calls that can be tested in place of the above.</p> <div style="clear:both;"></div><img src="http://192.168.2.20/aggbug.aspx?PostID=23947" width="1" height="1">http://192.168.2.20/blogs/doverton/archive/2007/07/13/how-to-connect-to-and-import-data-from-an-xml-web-service-into-excel-2007.aspx#13353Fri, 12 Mar 2010 13:19:48 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:13353 Sandip<p>Invalid Link <a rel="nofollow" target="_new" href="http://teachatechie.com">http://teachatechie.com</a></p> <div style="clear:both;"></div><img src="http://192.168.2.20/aggbug.aspx?PostID=13353" width="1" height="1">http://192.168.2.20/blogs/doverton/archive/2007/07/13/how-to-connect-to-and-import-data-from-an-xml-web-service-into-excel-2007.aspx#12998Mon, 25 Jan 2010 08:37:43 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:12998Paul<p>Links from this post are not valid.</p> <div style="clear:both;"></div><img src="http://192.168.2.20/aggbug.aspx?PostID=12998" width="1" height="1">