Excel for Mac
Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Single pivot from different tables in Mac
I am unable to create create a single pivot table from 2 different tables in a mac.
1 vote -
Pivot totals cannot be formatted independent of data columns
Pivot tables in Mac don't allow for total columns to be edited independently of the fields listed. I would like to summarise by average whilst maintaining the sum function in the columns.
1 vote -
Pivot totals cannot be formatted independent of data columns
Pivot tables in Mac don't allow for total columns to be edited independently of the fields listed. I would like to summarise by average whilst maintaining the sum function in the columns.
0 votes -
Please add Power Pivot to Excel on Mac !!!!!
Please add Power Pivot to Excel on Mac! Excel is just **** without Power Pivot
14 votes -
Summarise values in calculated field
The option to summarize values for a calculated field is greyed out in Excel for Mac
1 vote -
Pivot Table tabular form for specific rows
In Windows, you can format specific rows to either compact or tabular form without going classic. I want to be able to do that for Mac as well.
1 vote -
Power Pivot function on PC must ALSO be usable feature on Mac
Seems a rip-off that Mac users must pay the same price for MS Office only to be short-changed on the utility of the program. Mostly use Excel and Outlook. The latter is generally okay, but Excel lacks.
Control keys do not navigate properly on the Mac and/or display does not move properly, especially large files; and germain to this thread,
Building pivot tables on the Mac is an absolute pain in the ... while very simple on a PC. Learned (from MS support) that this is a feature called "Power Pivot" that simply is not available on the Mac. Makes…
2 votes -
When you will have Pivot Table relationships work in a Mac?
Why excel mac is diferente from excel windows?
1 vote -
Pivot Table source range independent lines
I have a journal of expenses chronologically ordered over the past years in one EXCEL sheet.
TO analyse them year by year, I need to insert Headers on every January first.
Can't EXCEL offer a possibility to select independent lines from the same source sheet to build a PivotTable of part of the data only?
E.g. while the PivotTable Headerline remains in line 1, I would ask you to allow to chose lines 1000 to 1500 as source to built a partial PivotTable out of the entire source sheet.1 vote -
Sort Pivot Tables by more than one variable
Allow a secondary sort on pivot tables if multiple values are the same. Currently, I have to calculate another variable to manually allow this feature.
Ex: the total # of sales is equal for multiple salesmen, the program should default to sorting by another field of my choice (ex: Total value of sales)
2 votes -
Intégrer le ODBC dans excel pour mac
J'ai besoin d'un information sur le ODBC pour mac. Comment intégrer le ODBC directement dans excel pour bénéficier de power query ?La procédure reste très complique pour des personnes non initiées.
2 votes -
office 365
Make power query and power pivot available for excel macOS.
3 votes -
Enable (or re-enable?) pivot table drill down
We're being asked to look into why Mac users can no longer double click into a pivot table to bring up a new tab with the relevant records attached. I've now had this from at least 2 people saying it used to work but a recent update (at least a month ago) has stopped it. I wasn't aware of this before it was reported so I don't know if it used to work or not. It's how our managers get their management accounts and so this is quite important. We're having to work around it with remote desktop services but…
1 vote -
Named Ranges Can't be Data Sources?
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.
3 votes -
Allow generation of pivot table from multiple sheets
Be able to create a pivot table from multiple sheets
6 votes -
3 votes
-
We need a manual sort option for Excel for Mac - where we can use a list
I find pivot tables are sometime a problem if I cannot sort the column headings properly or via a special list!
2 votes -
The new format for pivot table chart analysis is awful. Very limited in options from previous versions and I don't understand why.
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.
2 votes -
PivotTable
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.
2 votes -
Unable to create a Pivot table from multiple tables in Excel for Mac - seriously???
Create a pivot table from multiple tables (feature appears to be missing from Excel for Mac!)
19 votes
- Don't see your idea?