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.
-
Improving Pivot Tables regarding control source data and caches.
I had a big problem after an office update. My files couldn't be open correctly because some pivots had some links to other external files. But as the microsoft support told me it is not possible to delete those links to other files. I didnt understand why, but they told me a pivot table will never forget those links and I have to rebuild everything from the scratch. Please add a possibility to overview, add and delete all links to other files out of a pivot table.
Additional I ask my self why there is no window/funktion to visualize the…
1 vote -
PivotTable summarize
It would be very useful if you could define your own setting. For example, I never use the summary, it would be better for me if the default setting was average. It is very time consuming, for multiple data always open the pop-up window and change the setting.
1 vote -
When are you going to add power pivot to Mac Excel.
When are Mac users going to get POWER PIVOT on Mac Excel, feeling a little cheated.
1 vote -
Add the date model check box
Need to create a pivot t table by selecting the data model check box so I can use de "distinct cost function"
1 vote -
powerquery
Set up PowerPivot for Excel for Mac
1 vote -
PivotTable with Text - Add Measure
Allow a Pivot with text by adding the 'Add Measure...' feature to PivotTable Fields (as in Windows)
1 vote -
Pivot Table with data
I want no calculation on field "Value" (number, average, variance ...) but the value of field "Value"
Useful for filtering/Extracting and grouping multiples values for the label row field
No Excel functions to create
Thank you1 vote -
Please add PivotTables and Data Modeling to Office for Mac
See subject. Please add these features to Office for Mac. Thank you!
1 vote -
Set PivotTable default layout options
We need the magic of "File > Options > Data > Click the Edit Default" etc. to set PivotTable defaults. This feature exists for Windows. We know it's there and can see its value. It's time to bring it to Mac and set us free! ~ Who's with me? ~
1 vote -
Custom sort
Need the ability to custom sort
1 vote -
1 vote
-
Add filter options in Pivot graph in Excel for Mac
Add filter options in Pivot graph in Excel for Mac for better visualisation and flexibility
1 vote -
3 votes
-
When functions are not available in mac-version, please make them available in the online version (such as Power Pivot
When functions are not available in mac-version, at least make them available in the online version (such as Power Power) as well in the personal as the business accounts
1 vote -
Please add chart filters!
Please figure out Power Pivot so that we can have chart filters on Mac! I can't do some of my college work because of this!
1 vote -
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.
5 votes -
Single pivot from different tables in Mac
I am unable to create create a single pivot table from 2 different tables in a mac.
6 votes -
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 -
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
- Don't see your idea?