Refresh XML data from web in Excel

I'm using Excel 2010 to link a table to a XML file on my server. I'd like to distribute the Excel file to a group of people and have it updated every time the XML file is updated on the server.

In Excel, I'm pulling the data using "Data", "From Web" and then I type in the path of the XML file.

Excel then builds a table with all the data but if the XML file is updated on the server, the data remains static, even if I click "Refresh" or "Refresh XML data" on the table.

It should be able to download new data including new columns to the table, if any.

Is there a way to do this?

Hi,

Sorry I couldn't find an answer yet anywhere. But I did post the same question here:
http://stackoverflow.com/questions/1...m-web-in-excel

Thanks for your help.