A Ajju1234 New Member May 30, 2023 #1 i have 4 different excel workbook with 30k line items each and i want to make only pivot table from these sheets. please help
i have 4 different excel workbook with 30k line items each and i want to make only pivot table from these sheets. please help
AlanSidman Well-Known Member May 31, 2023 #2 Use Power Pivot to link each of the tables so as to allow you to pivot your information.