Excel link tables for pivot table

[Tgada]

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 not appear. Can you please help.

Thanks, JYB

[#2]

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.