Spreadsheet Compare 2016 does not work with 64 Bit Office 2016

Stacy BrownSenior Applications Administrator
Savvy IT chick completely obsessed with MS Office, the Olympics, Cairn Terriers, and solving murder mysteries!
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
6,168 Views
Stacy BrownSenior Applications Administrator
Savvy IT chick completely obsessed with MS Office, the Olympics, Cairn Terriers, and solving murder mysteries!

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.