Hi all, I'm got a problem that's driving me crazy and I'm hoping someone can help. I'm using excel 2010

I've got a data query running from an external website which I have no control over. It imports in xml which is great for how I want to format things. Trouble is I cannot find any way of updating the data at regular intervals. I have tried to use the normal methods in the connection properties but it doesn't work. I have tried to hard code a refresh with VBA but it doesn't work. The odd thing about it though is that if I click on the data tab>connections>properties>definition tab>edit query>refresh the web page>tick the xml table again and then import then the data refreshes! All I'm trying to do is that but automatically.

Can anyone fathom a guess as to why this is happening!? The website is http://www.pgatour.com/data/r/483/leaderboard.xml

Thanks