The difference with Comparing Excel files is that you specify which worksheets to compare. You can compare worksheets in different files or in the same excel file.
When comparing areas in a worksheet you have to decide if the data should be considered as being in a table (rows or columns) or not (range).
Select table (rows or columns) if you users add and remove row (columns) with data.
|Tutorials on comparing spreadsheets|