Share via

‘Export to Microsoft Excel’ from Internet Explorer 9 does not enter the URL in the Excel web query dialog

  • Article

Written by Amber Mertes

Internet Explorer 9 provides additional security that limits the functionality of the ‘Export to Microsoft Excel’ option within an Internet Explorer web page. This was a security design improvement to Internet Explorer
9.  

Steps to reproduce the issue:

1. Open Internet Explorer 9

2. Open any web page, for example: https://www.msn.com

3. Right click into the page and choose "Export to Microsoft Excel"

4. Excel will open and a window "new web query"

5. In the address bar you will see " https:/// " and the internet site will not be shown and an error is returned. The error displayed is:

Resolution

Copy and paste the URL from IE9 in to the Excel web query dialog where https:/// is located.

Additional note

We have also had reports of this option to ‘Export to Microsoft Excel’ not being available upon right clicking.

If this occurs, follow these steps:

** Important This article
contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

  1. Start > Open > Regedit

  2. Browse to:   HKEY_Current_User\Software\Microsoft\Internet Explorer\MenuExt

  3. Right click on MenuExt > New > Key:   Export to Microsoft Excel

  4. Right click on the ‘Default’ string value > Modify > Value Data:  res://C:\Program Files\Microsoft Office\Office14\EXCEL.EXE/3000

    Where drive is the letter of the drive where Excel is installed and where path is the complete path of the Excel.exe file.

REFERENCE:

826917  Nothing happens when you try to use the "Export to Microsoft Excel" command in Internet Explorer

https://support.microsoft.com/default.aspx?scid=kb;EN-US;826917

 

Update:
This was addressed in Office 2013. The Excel 2013 web query dialog now works as expected with the new security introduced in Internet Explorer 9.

Comments

  • Anonymous
    January 01, 2003
    Note that you need to restart PC after changing this key.

  • Anonymous
    October 02, 2012
    The comment has been removed

  • Anonymous
    October 04, 2012
    Any dynamically generated website cannot be exported in this manner. This is not a workaround.

  • Anonymous
    October 12, 2012
    Thanks for help with the registry! The option to export disappeared after updates I assume.

  • Anonymous
    November 05, 2012
    i read another post that said this would be fixed in IE10, tried to find IE10 for windows 7 and found out that IE10 is only for Windows 8. any idea if fixed in IE9 anytime soon since we are not looking at upgrading over 500 computers any time soon.

  • Anonymous
    November 23, 2012
    Now there is a IE10 version for win7 but the issue remains! It hasn't been fixed, its annoying.

  • Anonymous
    December 13, 2012
    I am getting error when try to use the "Export to Microsoft Excel" command in Internet Explorer9. The key value is fine in the registry. Any help??

  • Anonymous
    December 13, 2012
    I have home edition of office 2010 installed before that.

  • Anonymous
    January 25, 2013
    IE8 to IE9 improvement is really marvaleous. The new improved idea has initally some complications. However good soluation for IE9 Thank you

  • Anonymous
    February 07, 2013
    When is microsoft going to provide a real solution to this problem

  • Anonymous
    April 07, 2014
    gostaria de baixaro explore 09

  • Anonymous
    April 30, 2014
    The comment has been removed