Excel - ..has encountered a problem and need to close

Ask a question




Issue

I have a problem with Microsoft Excel;
Each time I open a file in MS Excel. Excel pops a message saying "MS Office Excel has encountered a problem and need to close" and it gives me the option to "Recover my work and restart MS Office Excel".

Solution

  • Click on Start > Run, type regedit and click OK.


After that navigate to: *HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\BtOfficeAddin\BtOfficeIntegration
  • Set LoadBehavior value to 3.

Note

Solved by spassky

Excel - Select the default number of processors to be used for calculations
Insert rows on change of value in excel table