I can't believe the mac version has this massive bug. You can only use hard-coded, specific ranges for a data source. The Windows version of Excel has no problem letting you use a named range for a Data Source. I noticed this affects pivot tables, charts and graphs. No named ranges allowed for data sources. Ridiculous.

Be able to create a pivot table from multiple sheets

I find pivot tables are sometime a problem if I cannot sort the column headings properly or via a special list!

Need to role back pivot table chart analysis and options. Very limmited options from previous versions. I can't get the right look and don't like the loss of control.

When I click into a PivotTable from out of it (just from out of it) or when I move the selected cell over a PivotTable and stop there in the moment the PivotTable Analyze and Design menus appear the keyboard arrows don't move anymore.

If I click again over any cell of the PivotTable (i.e., when the menus are already loaded) I can use the arrow keys - what I think should be done automatically.

Create a pivot table from multiple tables (feature appears to be missing from Excel for Mac!)

Include the option to add new items in manual filters (same as the one that exists in the windows version)

In PivotTable add the option to show subtotals only for rows OR only for columns, as is possible for grand totals.

Suppose you want to sort on the second column from largest to smalles. And values in the first column (if they have the same value in the second column) you want to sort alphabetically. I can't find a way to do this in Excel for Mac.

make Distinct Count available in value field settings for Pivot Tables in MAC

PivotTable and PivotChart Wizard works well on Windows. It is important to analyze data. I am sure most us our missing it

Why did this go away in excel 2016 on Mac? Bring it back I need it bad

Paste range name dialogue box opens in general worksheet functionality, but does not perform when defining range in pivot table range selection.

This short cut is invaluable for rapid multiple pivot definition.

Allow in Pivot Tables to calculate the percentage of items as part of a subgroup.

is it possible to open an existing Windows Power Pivot Excel on Mac?

I have already created a Power Pivot Excel report on Excel 2013.
Now i want to use that report on mac.Is there any way to do so?

When clicking the recommended pivottable button it doesn't bring up box with recommended pivot tables.

For the Pivot Table Field list, can you please have the option to make this dockable on the right like in windows excel? Please increase the size of the field name box. it starts off so small or allow (like in windows excel) the option to have the field boxes aligned vertically. Thanks.