Method 1: Scan Excel for Known Issues
2939112 How to resolve crashing or stability issues in Office programs by using the OffCAT tool
If your issue is not resolved after you use the OffCAT tool, go to method 2.
Method 2: Start Excel in safe mode
If your issue is resolved after you run Excel in safe mode, click the following article number to view the article in the Microsoft Knowledge Base:
If your issue is not resolved after you start Excel in safe mode, go to method 3.
Method 3: Investigate possible issues with COM add-ins
- Excel add-ins that are saved as .xla, .xlam, or .xll files.
- COM add-ins. These add-ins usually have to be installed and include DLLs and registry keys. COM add-ins created for one version of Excel frequently are not compatible with a newer version, and may cause crashes. They are not disabled by Safe mode.
The simplest way to resolve this possible cause is to run this troubleshooter.
If the troubleshooter resolves the issue, but it recurs, you’ll need to figure out which add-in is causing the problem. To disable COM add-ins, follow these steps:
- Select File > Options > Add-ins.
- At the bottom of the dialog box, change the Manage dropdown to COM add-ins, and select Go.
- Clear the checkbox for any enabled COM add-ins. select OK.
If disabling the COM add-ins alleviates the issue, try enabling them one at a time to test for the problem add-in.If these steps do not resolve your issue, continue to method 4.
Method 4: Investigate Excel file details and contentsExcel files can exist on the computer for a long time. They are upgraded from version to version and frequently travel from one user to another user. Frequently, a user inherits an Excel file but doesn't know what is included in the file. The following areas can cause performance or crashing issues:
- Formulas referencing entire columns.
- Array formulas referencing an uneven number of elements in the arguments.
- Hundreds, or perhaps thousands of hidden or 0 height and width object
- Excessive styles caused by frequent copying and pasting between books
- Excessive and invalid defined names
Method 5: Check whether your file is being generated by a third partySometimes Excel files are generated by a third-party application. In this case, the files may be generated incorrectly, and some features may not work correctly when you open the files in Excel. If this occurs, test the features in new files outside the third-party application. If the features work correctly, you should make sure that the third party is aware of the issue.
If your issue is not resolved after you test it outside the third-party application, go to method 6.
Method 6: Perform a selective startup to determine whether a program, process, or service conflicts with ExcelWhen you start Windows as usual, several applications and services start automatically and then run in the background. These applications and services can interfere with other software on your PC. Performing a selective startup (also known as a "clean boot") can help you identify problems with conflicting applications. To perform a selective startup, click one of the following links, depending on your version of Windows, and then follow the steps in the article:
Windows Vista: Run Selective Startup using System Configuration
Windows XP: How to create and configure user accounts in Windows XP
If your issue is not resolved after you re-create the profile, go to method 7.
Method 7: Check whether your antivirus software is up to date or is conflicting with ExcelAntivirus software can interfere with Excel, and cause performance issues. Frequently updating your AV software can alleviate the issue.
How to check whether your antivirus software is up to dateTo keep up with new viruses that are created, antivirus software vendors periodically provide updates that you can download from the Internet. Download the latest updates by visiting your antivirus software vendor’s website. For a list of antivirus software vendors, go to the following Microsoft website:
Consumer security software providers
How to check whether antivirus software is conflicting with ExcelIf your antivirus software includes integration with Excel, you may experience performance issues. In this case, you can disable all Excel integration within the antivirus software by creating exceptions for Excel files.
Important Changing your antivirus settings may make your PC vulnerable to viral, fraudulent, or malicious attacks. We do not recommend that you try to change your antivirus settings. Use this workaround at your own risk. You may have to contact your antivirus software vendor to determine how to configure software to exclude any integration with Excel.
If updating your antivirus software, and excluding it from integrating with Excel does not resolve your issue, go to method 8. continue to the advanced troubleshooting section.
Method 8: Verify or install the latest updatesYou might have to set Windows Update to automatically download and install recommended updates. Installing any important, recommended, and optional updates can frequently correct problems by replacing out-of-date files and fixing vulnerabilities. To install the latest Office updates, click the link specific to your version of Windows and follow the steps in that article.
Operating system updates
Install Windows update in Windows 8 or Windows 8.1
Install Windows updates in Windows 7
Install Windows updates in Windows Vista
Install Windows updates in Windows XP
Office updatesFor more information about the latest Office updates, see Office Updates.
If your issue is not resolved after you install the latest Windows and Office updates, continue to the advanced troubleshooting in the More Information section.
Advanced troubleshootingIf the methods that were mentioned earlier did not resolve your issue, the issue could be either file specific or environmental. The following section describes how to troubleshoot additional issue that can cause Excel to hang or to crash.
Environmental factorsEnvironmental factors are just as important as file contents and add-ins when you are troubleshooting crashes. You can help us determine the cause of your issue by taking the following actions:
- Follow basic troubleshooting steps.
- Test files in the cleanest possible environment.
Where the file is storedMoving the file locally will help determine whether there is something wrong with the file or with where the file is saved. Several issues can arise when you save an Excel file over a network or to a web server. It is a good idea to save the file locally. This should be done in the following scenarios:
• Offline files
• Opening files from Webfolder or SharePoint
• Remote Desktop/Citrix
• Network appliances
• Virtualized environment. For more information about Microsoft software that is running in a virtualized environment, click the following article number to view the article in the Microsoft Knowledge Base:
MemoryExcel files can grow fairly large when you start adding lots of formatting and shapes. Make sure that your system has enough RAM to run the application. For system requirements of the Microsoft Office suites, go to the following Microsoft websites:
System requirements for Office 2010
System requirements for Excel 2007
Office 2010 introduced native 64-bit versions of Office products to take advantage of this larger capacity. For example, this additional capacity is needed only by those Microsoft Excel users who require Excel spreadsheets to access more than 2 gigabytes (GB) of addressable memory. To read more about Excel and 64-bit editions of Office, go to the following Microsoft websites:
Printers and video driversWhen Excel is started, it examines the default printer and video drivers that will display the Excel workbooks. Excel is printer-intensive. Therefore, it will run even slower when Excel files are saved in Page Break Preview view. Testing the file by using different printers such as the Microsoft XPS Document Writer printer driver or the VGA video driver will determine whether the problem is with a specific printer or video driver.
Article ID: 2758592 - Last Review: Apr 18, 2017 - Revision: 6