Compare Two Excel Spreadsheets For Differences – If other people can edit the book, it may open completely and “Who changed this and what was done?” Comparison of Microsoft spreadsheets can answer these questions by looking for these changes and highlighting them for you.
IMPORTANT: Comparison of worksheets is only available with Office Professional Plus 2013 or Office 365 ProPlus.
Open Spreadsheet Comparison.
In the panel in the lower left corner, choose the options that the desire includes in the comparison of the book, such as formulas, cell format or macros. Or, if you prefer, select Select All.
On the Home tab, choose Compare