We need the ability to have page breaks in pivot tables for each change in item like Excel on the Windows platform has. Right now I have to manually set page breaks with each change of the pivot table.7 votes
Hi, there is an important function missing in Excel for Mac ... the repeat item labels in pivot tables. ¿Could you please add this function asap or tell me how could I do this? I really need it in order to copy and filter pivot table data. Regards, Tais21 votes
In older versions of excel I can easily "group" a time column and summarize it by day, month, etc. In Excel 2016 I can no longer get this to work with any data sets so far. Grouping the data just results in a "dumb" group with no summarization features.
I've found documentation of the "auto-grouping" feature for time in Excel, but this never seems to function or appear on my Mac....how can I replicate the legacy function??8 votes
In Windows you can select a filter drop down on a pivot table and search for something and select all. On a mac, when you search for something you then have to check all items matching the criteria.
Example: I want to filter by month and I have each day of the month in my filter field name. If I search "Aug" for "August" I then have to check August 1 - 31 rather than being able to just select all within the search.5 votes
In PivotTable add the option to show subtotals only for rows OR only for columns, as is possible for grand totals.
In PivotTable add the option to show subtotals only for rows OR only for columns, as is possible for grand totals.3 votes
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.3 votes
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.6 votes
As many people who works in a Business enviroment, I face off daily data files coming from DBases on Winservers machines.
Our Dbase export B.I. files with .cub extensions, who can be easily opened and analized with Excel 2010 or above. We have licensed Win and Mac 2016 versions, but Mac users cannot open .cub files...
Webought Excel for that, and we won't sell our Mac for Win PCs, so why buy MS appplications if they don't work on a Mac? For simple tasks, Libreoffice works great....21 votes
Thanks for submitting the request, but we simply don’t have an Analysis Services database engine that runs on the Mac. We’re investigating ways Excel on Mac might be able to work with tabular models that are loaded on servers, (either on-premise or in the cloud), but we don’t expect offline .CUB files to work on Mac Excel anytime soon.
- Don't see your idea?