XL2002: Export to Microsoft Excel Command in Internet Explorer Does Nothing

Article translations Article translations
Article ID: 277621 - View products that this article applies to.
This article was previously published under Q277621
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
Expand all | Collapse all

SYMPTOMS

When you right-click a Web page in Microsoft Internet Explorer, a shortcut menu with a command to Export to Microsoft Excel appears. If you click Export to Microsoft Excel on this menu, nothing happens.

You expect the Web page to be exported to Excel when you click Export to Microsoft Excel, and you do not expect the Export to Microsoft Excel menu command to appear if Microsoft Excel is not installed.

CAUSE

This behavior occurs in one of the following situations:
  • You remove Microsoft Excel.

    Notice that the Export to Microsoft Excel command remains on the shortcut menu that appears when you right-click a Web page.

    -or-
  • You remove Microsoft Excel and then reinstall Microsoft Excel in a new location on the computer.

WORKAROUND

To work around this issue, use one of the following methods:
  • Remove Microsoft Excel, and then re-install it in its original location.

    -or-
  • Edit the Windows registry to remove the command from the Internet Explorer shortcut menu, or to direct the command on the Internet Explorer shortcut menu to the current location of Microsoft Excel.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To edit the Windows registry key, follow these steps:
  1. Close all running programs on the computer.
  2. On the Start menu, click Run.
  3. In the Open box, type Regedit, and then click OK.

    Notice that Registry Editor appears.
  4. Click to expand the following subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\MenuExt\Export to Microsoft Excel
  5. On the Registry menu, click Export Registry File.

    Notice that the Export Registry File dialog box appears.
  6. In the File name box, type "C:\Export to Excel" (with the quotation marks) and then click Save.
  7. Either remove or edit the Export to Microsoft Excel command, as shown in the following steps:

    To Remove the "Export to Microsoft Excel" Command

    1. Click Export to Microsoft Excel.
    2. On the Edit menu, click Delete.

      Notice that the Confirm Key Delete dialog box appears.
    3. Click Yes.

    To Edit the "Export to Microsoft Excel" Command

    1. Click Export to Microsoft Excel.
    2. In the Name list, double-click (Default).

      Notice that the Edit String dialog box appears.
    3. In the Value data: box, type res://drive\path\EXCEL.EXE/3000, where drive is the letter of the drive on which Excel is installed, and where path is the complete path to the "EXCEL.EXE" file.
    4. Click OK.
  8. On the Registry menu, click Exit.
  9. Restart the computer.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Properties

Article ID: 277621 - Last Review: January 29, 2007 - Revision: 1.2
APPLIES TO
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbbug kbpending KB277621

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com