Thread: Problems with importing XML files

I have a problem importing XML files in Excel 2003. When I try to import several files at once, the importing goes fine, but then I cannot refresh the data. When I try to go to "Refresh XML Data" in the menu, that menu option is grayed out. Is there any way to work around that?

Thanks!

No ideas?

Well, basically I go to Data -> XML -> Import..., then browse to a folder in which I have multiple gpx files (xml-based files used to store location data, used with GPS units). Using Ctrl I select several of those files and click Import. They get imported fine. However, when I then go to Data -> XML, I see that Refresh XML Data is grayed out.

I am not sure what you mean by data sample. It seems to me the data itself is not so interesting. But I can upload the worksheet and the gpx files, if you think that will help.