How to troubleshoot startup problems in Excel (280504)

MORE INFORMATION

When you start Microsoft Excel, you may experience problems for any of the following reasons:

• Corrupted shortcut to the Excel program
• Problematic file in Excel startup folder or alternate startup file location
• Conflict with another program
• Incorrect version of a core Microsoft Office file
• Corrupted Excel toolbar file (*.xlb) or Excel .pip file
• Corrupted add-ins under the Tools menu
• Corruption in the registry keys
• Other problems when opening Excel files

If you receive an error message when you start Microsoft Excel, search the Microsoft Knowledge Base for the exact error message at the following Microsoft Web site: If you do not receive an error message, or if you cannot find specific information in the Microsoft Knowledge Base about the error message, use the following information to troubleshoot the Excel startup problem.

First, consider the scope of the problem. Does the problem occur when you start Excel by clicking a workbook file, or does it occur when you run Excel from the Start menu?

If the problem only occurs when you open an Excel file, please refer to the "Other Problems When Opening Excel Files" section later in this article. Otherwise, proceed to the next section.

Corrupted Shortcut to the Excel Program

If the problem only occurs when you start the Excel program, follow these steps:

1. Click Start, point to Search, and then click For Files or Folders.
2. In the Search for files or folders named box, type Excel.exe.
3. In the Look in list, click My Computer, and then click Search Now.
4. After the Excel.exe file is found, double-click the file to start Microsoft Excel.
   
   Note The typical location of the Excel.exe file depends on what version you have installed.

   Microsoft Office 2003

   C:\Program Files\Microsoft Office\Office11

   Excel 2002

   C:\Program Files\Microsoft Office\Office10

   Excel 2000

   C:\Program Files\Microsoft Office\Office

If Excel starts as expected, the problem may have been due to a corrupted shortcut to the program. To resolve this problem, create a new shortcut to the Excel program that you can use to start Excel.

If Excel does not start as expected, follow these steps to run Excel in Safe mode.

Start Excel in Safe Mode

1. Click Start, and then click Run.
2. Click Browse, and then locate the folder where Microsoft Excel is installed, as specified earlier in this article.
3. After you locate the Excel.exe file, click the file to select it, and then click Open.
4. At the end of the path in the Open box, type a space and then type /s so that the entire line appears similar to the following:

   "C:\Program Files\Microsoft Office\Office\Excel.exe" /s

If Excel starts as expected, see the "Additional Troubleshooting" section later in this article for more information.

If Excel still does not start as expected, a conflict with another program may exist. Try to restart Windows in Safe mode, and then perform the previous steps again to run Excel in Safe mode.

For additional information about how to start Windows in Safe mode (clean boot), click the following article numbers to view the articles in the Microsoft Knowledge Base:

Excel Does Not Start in Safe Mode and Windows Is in Safe Mode

If Excel does not start when you use the /s switch and Windows is running in Safe mode, remove Microsoft Office (or stand-alone Microsoft Excel) by using the Add/Remove Programs icon in Control Panel. Please refer to your Windows documentation for more information.

This step may be necessary because when you run both Windows and Excel in Safe mode, Excel is in the most basic mode that is required to start the program. This means that no other programs or files are involved in the Excel startup process. Therefore, the problem may be due to a corrupted Office file that Excel uses to start. If you remove and then reinstall Office (or stand-alone Excel), it should resolve this problem.

For additional information about a related issue with incompatible Office 2000 files, click the following article number to view the article in the Microsoft Knowledge Base: If the article above does not help, or if restarting Windows in Safe mode resolves the Excel startup problem, please see the "Additional Troubleshooting" section in this article for more information.

Additional Troubleshooting

Excel Starts When You Use /s Switch

If Microsoft Excel starts as expected when you use the /s switch, "Safe Mode" appears in the Excel title bar. This indicates Microsoft Excel is running as if it were the first time after the initial installation.

Now that you have started Excel, use a process of elimination to step through the following areas that Excel bypasses in Safe mode, until the problem is corrected.

Excel Startup Folders

One of the more common reasons you may experience problems when you start Excel is that Excel is loading a problem file from one of its several different startup folders.

Excel Toolbar File

Occasionally, the toolbar file for Excel can become corrupted. If this occurs, you may experience problems when you start Excel. In this situation, locate the toolbar file and rename it. After you rename the toolbar file, Excel rebuilds a new toolbar file the next time you start Excel.

For example, if your toolbar file name is JoeUser8.xlb, rename the file to JoeUser8.old. Then, start Excel, and notice that Excel creates a new JoeUser8.xlb file in the same location as the original toolbar file.

For additional information about the Excel toolbar file and how to identify it, click the following article numbers to view the articles in the Microsoft Knowledge Base: For additional information about another toolbar problem when you start Excel, click the following article number to view the article in the Microsoft Knowledge Base: Excel.pip File

Excel remembers what menus and commands have been used and displays these most recently used menus first. Excel hides the unused commands in its expandable menus. Excel stores this usage data along with menu animation settings in a file named Excel.pip.

This file can become corrupted. If this occurs, you may experience problems when you start Excel. In this situation, locate the Excel.pip file and rename it. After you rename the file, Excel rebuilds a new .pip file the next time you start Excel. Use the Windows search feature to locate the Excel.pip file.

Excel Starts When Windows Is in Safe Mode

If the Excel startup problem no longer occurs when Windows is in Safe mode, some other program is causing the problem with the Excel startup process.

Use a process of elimination to determine exactly what program is causing the problem. If you are unsure of how to do this, contact your Windows vendor for more information about how to eliminate each individual program that loads on Windows startup.

For additional information about how to troubleshoot Windows startup, click the following article numbers to view the articles in the Microsoft Knowledge Base:

Corrupted Add-ins Under the Tools Menu

On the Tools menu, click Add-Ins. Click to clear the check boxes for any add-ins that are selected, and then click OK.

Corruption in the Registry Keys

Remove the following registry keys.

Note Removing the following registry keys may reset customized user settings for your Microsoft Office programs.

Excel 2003

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0

Excel 2002

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0

Excel 2000

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0

Other Problems When Opening Excel Files

If Excel experiences problems only when you open specific Excel files, you must use a different approach to troubleshoot the issue. You may need to do anything from disabling macros to rebuilding the workbook.

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base: