No announcement yet.

Table Compare finding differences

  • Time
  • Show
Clear All
new posts

  • Table Compare finding differences

    This seems like it should be straightforward - maybe I'm missing something. I'm comparing two large xlsx spreadsheets, with hundreds of columns. When I open them in Beyond Compare, I see them side-by-side as expected. Pretty much every row has a difference somewhere. But I don't know how to figure out where the difference is. Differences are highlighted in red if I scroll to the correct column, but do I have to scroll all the way through the columns and visually compare to find the differences, or is there a way to simply jump to where the differences are?

  • #2

    The Table Compare deals with full rows, so it doesn't have the same horizontal navigation like the Text Compare (Ctrl+Shift+N to next difference). The Table Compare does have an option to remove any columns from view that only contain equal cells. In the View menu -> Columns dialog, if you show only the Difference Columns, does this help?
    Aaron P Scooter Software