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

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

Steps to reproduce the issue:

1. Open Internet Explorer 9

2. Open any web page, for example: http://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 “http:///” and the internet site will not be shown and an error is returned. The error displayed is:


Copy and paste the URL from IE9 in to the Excel web query dialog where http:/// 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.


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



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 (12)

  1. Anonymous says:

    Note that you need to restart PC after changing this key.

  2. HUH? says:

    This is not a FIX! Why can't Microsoft do something ??? It has been going on for YEARS! the same issue appears in IE10, Instead of sitting on their asses trying to confuse users FIX IT!!

  3. .... says:

    Any dynamically generated website cannot be exported in this manner. This is not a workaround.

  4. kim says:

    Thanks for help with the registry! The option to export disappeared after updates I assume.

  5. P says:

    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.

  6. SS says:

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

  7. Srinivas says:

    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??

  8. Srinivas says:

    I have home edition of office 2010 installed before that.

  9. Sekhar says:

    IE8 to IE9 improvement is really marvaleous. The new improved idea has initally some complications. However good soluation for IE9

    Thank you

  10. Joe says:

    When is microsoft going to provide a real solution to this problem

  11. alyne dos santos says:

    gostaria de baixaro explore 09

  12. Really???? says:

    This isn’t aimed at you Amber but fix your stuff Microsoft. You said you would fix it in IE10 and you haven’t. The average goober in a corporate setting isn’t going to think outside the box and copy and paste. They’re gonna call the help desk and beetch. And when you tell them they now have to do this, they’re going to cry a lot worse than I am right now. As soon as we find a way to manage it through policy, we’re switching to Google Chrome. The last bastion of Microsoft dominance is business environments and I see that eroding sooner rather than later. Really tired of simple things not being addressed.