Bring back PivotTable and PivotChart Wizard in Excel for Mac.
Need to use different grouping from same source data. Functionality should be the same as Windows version. Without clearing cache for new table data grouping is consistent across all tables linked to same data source. I have one table in days but would like another table from same source but I years. It converts both tables to year altering the whole analysis. This affects slicers too. Workaround would be to inefficiently copy data source to another table with same data bit different name. So you would be C&P data from one table to the other. Not efficient at all.
