XML not opening properly in EXCEL

[Guest]

Hello,

I am having some trouble opening XML in Excel. I have a web program that
will perform a query and export the results in XML format. I have some users
on Office 2003 PRO and SBE, whenever a user opens the file in PRO, they get a
dialog box that prompts them with three options, open as XML list, Open as
Read only file, and one more. Once I see this I know the file will be
formated properly with the headers on each column.

Now when a person using SBE opens the same file they do not get the same
dialog box, the file just opens and all the headers are messed up.

If you need an example I can supply screen shot and send them to you.

Thanks for your help

Andrew Wong

 

[Guest]

I found my answer in another post. It is not available in SBE, you can open
XML, but custom formating is not available. You have to have professional in
order to customize XML in Excel.