Excel 2013 - Import From Web with Basic Auth - Display issue

Copper Contributor

Hello all,

 

Im having an issue with Import From Web option in Excel 2013, which occurs only when loading an Xml file through a Web Url that needs a Basic Authentication.

 

Loading an XML file through a web service of mine, I have some data nicely displayed as a table in Excel.

But loading the same XML Data with an API with Basic Auth, the Load From Web form ask me for the login/pwd, it loads well the data, but not nicely displayed as a table in Excel,

 

Is there any workaround for this issue?

 

Thx for any help, opinion on this,

 

michael

 

 

0 Replies