Forum Discussion

Tgada's avatar
Tgada
Copper Contributor
Nov 02, 2019

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

 

Thanks, JYB

excel

1 Reply

  • Jens Stolle's avatar
    Jens Stolle
    Copper Contributor
    Nov 03, 2019
    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.

Resources