Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List

About this tutorial:

Video duration: 6:27
Download File:
Learn how to build a PivotTable report from two tables without using VLOOKUP. Learn that in Excel 2016 when you add two tables to the PivotTable Field list and drag and drop fields, the Auto Detect Feature can build your Relationship for you. See how to create two Excel Tables, Add to Data Model using Create PivotTable Field list, drag and drop field and create Relationship between the two Products Field using the Auto Detect Relationship feature.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

9 thoughts on “Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List


    (March 13, 2019 - 10:13 am)

    GREAT TIP right there!

    S Debs

    (March 13, 2019 - 10:13 am)

    Nice to excel getting new features to simplify tasks. Thanks for the video.

    Sal A

    (March 13, 2019 - 10:13 am)

    Great video…but gov't computers won't have Excel 2016 until 2020. On average they have a 4 year lag.


    (March 13, 2019 - 10:13 am)

    Another new feature on the Podium !


    (March 13, 2019 - 10:13 am)

    Thanks Mike

    Samir Mammadov

    (March 13, 2019 - 10:13 am)

    Hi. I am Samir from Azerbaijan Republic and I think that this teacher is the best of the best teacher whenever I see. He is just amazing and I wish him health and all good things. Sorry for my English.

    Don Pistulka

    (March 13, 2019 - 10:13 am)

    I am running office 365 and have the home version. When I try to refresh the pivot tables I get."Microsoft Excel isn't installed correctly. Please reinstall or repair the installation". This only happens when I try to refresh this pivot table. Are you sure all Excel 2016 versions can handle this relationship between two tables?

    Procv Tube

    (March 13, 2019 - 10:13 am)

    Amazing! I'm your Fan. I created my channel because of you man. Congratulations!!!


    (March 13, 2019 - 10:13 am)

    That's fantastic!

Leave a Reply

Your email address will not be published. Required fields are marked *