This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I'm trying to build relationships between tables on Excel 2016 for Mac, and I can't seem to figure out how to do it. The goal is to build a relationship between two tables and then to create a PivotTable for them. How do I do this?
I am a brand new Excel user, so, if possible, a step-by-step walkthrough would be greatly appreciated!
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Refer to the link by Jim Gordon MVPwith regards to building relationships between tables on Excel 2011.
Hope this would give you a head start on the same with 2016.