And as the following images show, the Compare and Merge Workbooks button appear at the top of the Excel window.Ģ. Quick Access toolbar, I performed the steps provided in this Although, the Compare and Merge Workbooks feature is available in all versions of Excel 2016, Excel 2013, Excel 2010 and lower, this command is not displayed anywhere in Excel by default. I did a test with the latest version of Office 365 for Business on my side, but I can use the Compare and merge workbooks to compare workbooks correctly.ġ. Sorry for the inconvenience it may have caused you. What can I use instead ifĪll I want is to Compare? Someone must have found an option. I absolutely LOVED the compare and merge workbooks feature. What other options are there to see what is different between two workbooks? I can't believe Microsoft would bury or block a feature without another way to cover it. After speaking with countless people to try to make it work, I feelĬonfident I have the answer: Not going to happen. I NEED a tool to help me find out what changed. That sounds simple if you can actually tell what changed. The changes you want to keep from one workbook to another. The article in support says that when you get Upload Failed error message, that you should simply copy I can opt to use the old Share Workbook (legacy), but it doesn't work either because we use Tables in our files.
With Business, this is not available with the new collaboration which With Personal, I used Merge and Compare workbooks, but only to COMPARE. Before I had that, I used Office 365 Personal.