This will allow you to figure out which add-in is causing the problem. Be sure and restart Excel each time you enable an add-in. Excel 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 things can cause performance or crashing issues:. Sometimes Excel files are generated by a third-party application. In this case, the files may be generated incorrectly, and some features may not work properly 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, continue on to the next item on the list.
When you start Windows, 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, choose one of the following links depending on your version of Windows, then follow the steps in the article:.
Selective startup is used to help identify the offending process, service, or application that conflicts with Excel. If your issue is not resolved after you re-create the profile, continue on to the next item on the list. Repairing your Office programs can resolve issues with Excel not responding, hanging or freezing by automatically repairing errors in Office files. For instructions on doing this, see: Repair an Office application. If repairing your Office programs did not resolve your issue, continue on to the next item on the list.
To keep up with new viruses that are created, antivirus software vendors periodically provide updates that you can download from the Internet. For a list of antivirus vendors, see: Consumer security software providers. Check whether your antivirus software is conflicting with Excel:. If 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. Or, you can disable any antivirus software add-ins that are installed in Excel. Important: Changing your antivirus settings may make your PC vulnerable to viral, fraudulent or malicious attacks. Microsoft does not recommend that you attempt 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 your software to exclude any integration with Excel or to exclude scanning in Excel.
If the methods that were mentioned earlier did not resolve your issue, the issue could be either file specific, or environmental. I have the same question 6. Report abuse. Details required :. Cancel Submit. Nayana S M. To help you better, we need few details about the issue. Does the issue occurs with multiple users and workstations? How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.
In reply to Nayana S M's post on May 6, Thanks for your response. Why is it saying my Excel File is corrupted? Protect your current computer from files on another computer. The Excel or Word file is damaged. So the first step everyone should take is to explore the possible reasons why they are included in Excel workbooks. It sometimes happens that the antivirus program running on your computer scans the Excel file and inserts extra text between the Content Type sections, such as the Content Location section of the header, which usually makes the file less readable.
The Excel you are using is not compatible with the Excel file. For each previously stated reason, there is a corresponding and easily presented solution below that you can try. Before opening the Excel file, close or disable your antivirus to prevent it from scanning the file and changing its tags and h2.
Then open the file to see if the solution works. Open Microsoft Excel Luckily, Microsoft provides you with a powerful built-in repair feature in Office Components, although the way to use it should definitely be a little cumbersome. Step 3. On the right side of each window, click Browse, locate the file and select it. Instead of constantly opening the file, click the All arrow next to the Open box to add the volume to the dropdown menu.
0コメント