Forum Discussion
bgx vsp
Mar 19, 2018Copper Contributor
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-...
- Mar 19, 2018
Hi,
It depends on options, but in general it shows both. Entire picture looks like this
Range on the left is actually the table.
Matt Mickle
Mar 19, 2018Bronze Contributor
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")