none
ERRORS occurs in Excel 2013 with get data from web function

    Question

  • Hello,

    why excel 2010/2013 could not import the web page(as shown below)

    I tried to use HTTP transaction monitor software (such as: fiddler) to monitoring the request. I found excel 2003/2007 is use "GET" method to request, but excel 2010/2013 is use "OPTIONS" to request this address "en/Institute/OnlineService/VDE-approved-products/Pages/".   So strange!!

    if there is excel setting/configuration or alternative workaround to fix the problem, thanks

     

    Website

    Excel 2003/2007

    Excel 2010/2013

    http://www.vde-institut.com/en/Institute/OnlineService/VDE-approved-products/Pages/Details.aspx?vdeProduct=40008366

    Import successfully

    Prompt windows security, ask user to input credentials,   even input correct windows account and password, import failed.

     

    Many Thanks

    Michael


    Thursday, November 07, 2013 5:31 AM

All replies