I am using Excel 2007 and using a Web query I can pull in a bookmakers XML feed and extract the information I require no problem.
My problem is I want to refresh this data every 5 minutes to get the latest data. The problem is the Refresh option under the connections tab doesn't work!
I have been searching for ages to find a way to do this without success....any help appreciated!