Spreadsheet Compare 2016 does not work with 64 Bit Office 2016

Stacy BrownSenior Applications Administrator
Published:
Updated:
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016

If you have taken the plunge and are moving to the 64 Bit version of Office 2016 please be aware that as of 28 March 2017, Spreadsheet Compare 2016 will not work.   It works fine in the 32 bit version  but breaks when moving to 64 bit.


After hours of trial and error and searching the web, I found that many people have experience the problem but no one had a solution.  I opened a ticket with Microsoft and within a few days they were able to present me with a reg key that fixes the issue.  So I thought I would share it here.


Here is the reg key information:


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

"EnableADAL"=dword:00000000



2
4,137 Views
Stacy BrownSenior Applications Administrator

Comments (1)

Commented:
Thanks Stacy!! Worked for me perfectly! I installed a few of the Office 2016 64-bit and 6 months later, "my Spreadsheet Compare doesn't open up!"
One trip to Experts Exchange and I have a fix courtesy of Stacy.

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.

Get access with a 7-day free trial.
Continue Growing Your Skills and Your Career
  • Interact with leading experts on your specific technology problems.
  • Receive the guidance of experienced professionals.
  • Learn from troubleshooting others have experienced.
  • Gain knowledge from a library of courses, all included.