24170 How to troubleshoot crashing and not responding issues with Excel

24170 How to troubleshoot crashing and not responding issues with Excel


How to troubleshoot crashing and not responding issues with Excel

 

Method 1: Start Excel in safe mode

Safe mode lets you safely use Excel without encountering certain startup programs. You can open Excel in safe mode by pressing and holding Ctrl while you start the program or by using the "/safe" option (that is, excel.exe /safe) when you start the program from the command line. When you run Excel in safe mode, it bypasses functionality and settings such as alternative startup location, changed toolbars, the xlstart folder, and Excel add-ins. (However, COM add-ins are excluded.)

If your issue is not resolved after you start Excel in safe mode, go to method 2.

 

Method 2: Investigate possible issues with COM add-ins Many developers create add-ins for Excel. These add-ins are divided into two types:

·         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 incompatible with a newer version, and may cause the system to stop responding. They are not disabled by safe mode.

.  add-in is causing the problem. To disable COM add-ins, follow these steps:

1.    Select **File **> **Options **> Add-ins.

2.    At the bottom of the dialog box, change the Manage dropdown to COM add-ins, and select Go.

3.    Clear the check box 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.


Solomon

    • Related Articles

    • 27479#File Explorer Not Responding in Windows 10

      File Explorer Not Responding in Windows 10   Right click on Quick Access then click on Options    Then select This PC from Combo box after that select the two check box as shown on the image then click on clear   Hop this help you to fix the above ...

    • 27751:- Microsoft Office has Identified a Potential Security Concern – Excel

      Fix: Microsoft Office has Identified a Potential Security Concern – Excel   While working in Microsoft Excel, you may receive a security notice prompt about certain data connections in your Excel spreadsheet being blocked. The warning message is as ...

    • #26611 Working with multiple users on the Shared Excel sheet at the same time

      First, open the shared Excel file Select REVIEW tab -> Share Workbook Menu Bar When you select Share workbook the first time the below trust center message will appear, select Ok. Trust Center Message On Excel menu click on File -> options -> Trust ...

    • call for action / portal not responding

      24164: -I have created Etitservicedeski@gmial.com account as FTP alternative Password is Abcd@1234 you can upload and download any document software at anytime in case of password issue Password recovery is Duty phone +25191125544 these ticked is ...

    • Install ET CRDS excel converter

      14636/ to solve CRDS problem pls copy file from this path \\svhqrep02\HelpD\Applications\In-house\Win-32 EAL folder to c:\program file and create short cut and run it as administrator then you extract 'xls' file from any ".txt " row data. 24164\\also ...