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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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:

Close all running programs on the computer.
On the Start menu, click Run.
In the Open box, type Regedit, and then click OK.

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

Notice that the Export Registry File dialog box appears.
In the File name box, type "C:\Export to Excel" (with the quotation marks) and then click Save.
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.
On the Registry menu, click Exit.
Restart the computer.