Hey Everyone,

As the title suggest, I am trying to connect a slicer to two different pivot tables with different data sources.
I found some videos online that suggest you have to base the pivot tables on the workbooks data model rather than the data in the worksheet.
The video tells me to delete the pivot tables and recreate them, basing them on the data model, rather than basing them on two tables on the worksheet.

The problem is that when creating the pivot table the video tells me to tick the box: 'add this data to the data model'
However, I am using excel for mac which does not seem to have this option available.

Is there a work around for this?

Thanks!

FYI, here is the video for your reference https://youtu.be/p9VD0rsC_bk