Forum Discussion
How to compare different pivots in two different excel workbook? Urget help
Hi
I really need help...
I have received two excel workbooks that pivot tables not the raw data for sheets
my task is to compare the numbers of two excels(pivots)
I tried to do it by ctrl-a selecting everything and paste as a value
but the data is huge my laptop is not ok with it.
is there any solution to compare these two huge pivot tables without having raw data of sheets....
if yes? how?
4 Replies
Afraid not, it's better to compare data sources
Thanks. How can I compare 2 different excel workbooks? with huge data
but they don't have the same row or column
only some similarities
with lots of hierarchy
Power Query could work, but it's hard to say not seeing the sample
