Share via


Excel 2016 Spreadsheet Compare crashes on startup

Question

Wednesday, March 28, 2018 10:22 PM

I'm using Office Pro Plus 2016 x64 on Windows 10 Enterprise x64. Spreadsheet Compare crashes on loading with the message "Microsoft Office 2016 component has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available." The program crashes whether I invoke it outside of Excel for from the Inquire tab in Excel.

I did a repair of Office in case something was corrupt, but the program still crashes.

I've noticed problems with this program in Office 2013 but no real solution. Any clues on how to get this working? Thanks!

All replies (7)

Thursday, March 29, 2018 9:31 AM | 4 votes

Hi,

Please try this method, try to change the regkey, open Resigtry Editor and go to this panth:

HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\Identity

Change the "EnableADAL"=dword:00000000

Please try this method, if this problem still existed please change the installation source and uninstall Office 2016 completely from PC and reinstall. About how to uninstall Office completely please refer to this support article and try the Option 2:

https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8

Any updates please let me know and I'm glad to help you.

Regards,

Emi

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].


Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.


Tuesday, April 3, 2018 8:43 AM

Hi,

Any updates about your problem now?

I'm glad to help you.

Regards,

Emi

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].


Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.


Monday, May 28, 2018 7:15 AM

This solution worked for me. The registry entry was not present in my registry, so added it myself and now it works again. Thanks!


Tuesday, September 18, 2018 6:22 PM

+1 this solution also worked for me in my workplace, thank you for your input.


Monday, July 15, 2019 6:58 PM

This solution worked for me as well. Thanks!


Wednesday, November 6, 2019 11:26 AM

Old thread, but maybe I should share the info once we got it working without disabling modern authentication (registry fix).
We have Office Pro Plus 64, 16.0.4849.1000

The key is that it misses the registry branch: 
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\Identity\Identities\3dd8e10e-451d-41f0-8fa8-xxxxxxxxxxxx_ADAL

You can get it by simply logging onto O365 via Office, for example word.

  1. open word
  2. navigate: File --> Account --> sign out (probably it is "logged in", but not really)
  3. when logged out, then sign in with UPN
  4. registry should have now the ADAL-branch

Tuesday, November 19, 2019 9:20 AM

works for me<audio controls="controls" style="display:none;"></audio>