Share via

Pivot Tables - Including Data from Multiple Sheets

Anonymous
2017-03-27T14:45:10+00:00

Hi All,

I want to include data from multiple tabs (they all have a similar table breakdown and formulas) and have them as data ranges in one pivot table.  However, I read the pivot table help tab thoroughly, and this is their recommendation.

They state to "add this data to the data model."  Now looking at the most recent version of Excel, this is what I have in front of me.

As you can see, they completely removed the "multiple tables" function.  Can ANYONE tell me where I can find that function now?  I'm using a Macbook as well.

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-03-27T16:41:41+00:00

    Hi Rebecca,

    This feature is not available in Excel 2016 for Mac. We suggest you vote this UserVoice: Consolidate Multiple Data Sources in a Pivot Table because this is the best way to make our products and services better for you and others.

    As a workaround, you can refer to Consolidate multiple data sources in a PivotTable (applies to: Excel for Mac 2011).

    Thanks,

    Rena

    3 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest