How to compare different pivots in two different excel workbook? Urget help

Question

Hi&nbsp;I really need help...I have received two excel workbooks that pivot tables not the raw data for sheetsmy task is to compare the numbers of two excels(pivots)I tried to do it by ctrl-a selecting everything and paste as a valuebut 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?

sergeibaklan · Answer

Parisa20000&nbsp;
Afraid not, it's better to compare data sources

parisa20000 · Answer

SergeiBaklan&nbsp;Thanks. How can I compare 2 different excel workbooks? with huge databut they don't have the same row or column&nbsp;only some similaritieswith lots of hierarchy&nbsp;

sergeibaklan · Answer

Parisa20000&nbsp;
Power Query could work, but it's hard to say not seeing the sample

parisa20000 · Answer

Can you please show me How to compare two excel files in which rows and columns are not the same?

Forum Discussion

How to compare different pivots in two different excel workbook? Urget help

Share

Resources