Forum Discussion
Excel link tables for pivot table
Hello, I use Excel for MAC (16.16.13) and I would like to retrieve data from different tables in 1 Pivot table. I tried to use link tables capabilities, but in DATA MENU the functionalities do n...
As far as I remember you have to check "Use data model" when creating the pivot table, only then you can query data from different tables for one pivot.