We have an XML file that we would like to open in Excel. We have tried two methods. Both have failed.
First, we tried opening Excel, browsing out to the file, and simply opening the file. But, upon trying to do so and using one of the suggested methods, we get an error saying "cannot load the specified XML".
Also, we have tried opening the XML file by opening Excel, choosing "Data", "Get Data", "From File", and "From XML", we get the error message "XML processing failed...Data at the root level is invalid".
How can we, then, open an XML file in Excel?