Forum Discussion
Solved
How smart is Compare Files aka Spreadsheet Compare?
I found out about the Compare Files is a feature in Pro Plus:
https://support.office.com/en-us/article/compare-two-versions-of-a-workbook-by-using-spreadsheet-compare-0e1627fd-ce14-4c33-9ab1-...
Hi,
It depends on options, but in general it shows both. Entire picture looks like this
Range on the left is actually the table.
This tool is nice to have. It will even track changes to VBA. If you are trying to compare worksheet changes you may also benefit from using the FORMULATEXT() Function in conjunction with an IF() statement. This can help you compare different formulas from one version of a workbook to another to manually see where formula changes have occurred.....
=IF(FORMULATEXT(Sheet1!A1)=FORMULATEXT(Sheet2!A1), "", "Different Formula")