Multiple Tables as Pivot Table data source in Mac - How to select data from multiple tabs to add to a Pivot Table?

Question

How can you select data from multiple tables in different tabs in excel in order to have an aggregated view in a pivot table?

Ie, I have tabs

A - Table A

B - Table B

C - Table C

Let's assume that the tables all have the same header, and that I want to create a pivot table in another tab (ie, D), which has tables A, B and C as its data source. Is it possible to do this in Excel for Mac?

I see Windows tutorials that do seem to have an option, but the Mac wizard doesn't look like this, and I see no option to do so...

Does anyone know how to do this in Excel for Mac?

Version is latest busniess 365, updated just today (I have tried both Excel desktop version and web version opened from sharepoint.

Thanks a lot for your help!

Best,

Pablo

Answer 1

Hi Pablo,

Thanks for posting in the community.

According to your description, you want to use multiple tables to create a Pivot Table on Excel for Mac. I am afraid, not like Excel for Windows, you can’t add the table to the Data Model. Based on my search, here is a thread where members discussed the same issue. Please check if it helps.

Base on the situation, I would like to invite you to vote for the suggestion in our UserVoice community where other members voted for the same idea. It’s the platform for us to hear your voice and improve our products.

Appreciate your understanding and patience.

Regards,

George