This may work: I've copied|pasted one set of data under the other.
Then add an additional column to serve as an indicator (old or new).
Then created the pivottable with that indicator as a column field. Then I'd
usually convert to values and add a few formulas to look for differences. Apply
Data|filter|autofilter to find them.
Another option that may not work.
I've changed the values of the "new" data to negative
put -1 in an empty cell and copy it.
select the new (numeric only) data and edit|paste special and click multiply.
Then I could just look at the number and see differences.
