Excel for Mac
Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more
-
Add PowerPivot to Mac excel
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?4,209 votesThanks for supporting this suggestion with your votes. It’s unlikely that we’ll be able to bring PowerPivot to Excel for Mac, because it relies on features of the operating system that don’t exist on Mac OS. We’ll keep tracking votes, since we know that the scenarios made possible by PowerPivot are important, even if the solution will need to be something else.
-
Add support for Get & Transform (formerly Power Query)
Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)
4,002 votesHi all! We have recently extended the list of supported sources you can refresh your Power Query queries from in Excel for Mac. In addition to refreshing your data from Text, CSV, JSON and XML files, you can now refresh your data from the tables and ranges in the current workbook, as well as from SQL Server database. For more information about Power Query features that are currently supported in Excel for Mac, please take a look at the following support article:
https://support.microsoft.com/office/7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5Guy Hunkin
Principal Product Manager, Excel Team -
Enable VBA Support for creating and editing UserForms (not the Data Form)
In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.
(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)
1,426 votesThanks for all your votes and comments about enabling support for UserForms in Excel for Mac.
With emphasis on enabling more and more capability using Office add-ins in Excel that will work across platforms, we don’t expect to add support for creating and modifying UserForms.
Please see this article for more information about what you can do in Excel with Office add-ins.
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-overview -
Add Evaluate Formula to Mac app
Please add the evaluate formula dialogue box to the mac app. With it you can evaluate a formula step by step and see which part of the formula works and where the problem is.
884 votesThanks for your support for this issue. While we do have it on our to-do list, we don’t expect to add this in the short-term, so we’re marking it Not at this time. We’ll continue to monitor the votes on it.
-
Restore data form functionality (different from VBA UserForms)
I miss the data form feature available in previous versions of Excel and would like to see it restored in Excel for Mac. Note that the Data Form feature is not the same as VBA UserForms. There's a separate suggestion if you want to vote for VBA UserForms.
445 votesThanks for the suggestion about the Data Form. We don’t have plans to implement this in the near future, so we’re marking it “Not at this time”.
We recommend using Tables to make data entry easy. To create a table, just press CMD+T. With a table, you can press TAB to move across the fields and then it will automatically go to the beginning of the next line if you’re at the last field. If you’re on the last record in the table, it will add a new record to the end of the list.
Please comment to let us know what other reasons you’re using the Data Form that make it easier/better than using a Table.
-
Add Find all in the Mac app
IN the windows version you can click on the button find all when you are in a search box. This then shows you all cells which contain your search criteria in a list. Please add this feature to the Mac app, too!
365 votesThanks for all your comments and votes supporting this suggestion. Please keep adding votes. We are considering this for a future update.
Thanks – Steve K [MS Excel]
-
Please Add Quick Analysis for Formatting
Quick Analysis is available on Windows Excel 2016, but not Mac 2016 - please add.
342 votesThanks for supporting this idea with your votes. We don’t have a plan to add this feature in the near future, but we will continue to keep tracking the votes.
Steve K [MS Excel]
-
338 votes
Thanks for the suggestion and the votes about 3D maps. We will continue to monitor the suggestion and prioritize it accordingly.
Steve K [MS Excel]
-
Please add a function to insert .pdf documents into excel speadsheets
I'd like to be able to add embed a .pdf document in a spreadsheet, and view it as either an icon or a link to the embedded document.
Thanks.
335 votes -
Allow exporting of Sharepoint lists
It would be great if you could export a Sharepoint list to Excel for Mac. At present you have to use Excel on a PC - as I believe this requires some kind of ActiveX component.
287 votesThanks for all the votes about this suggestion! We know that a lot customers are asking for it. Please continue voting! Your votes help us to prioritize the investments.
Guy Hunkin
Principal PM, Excel -
ALT key ribbon access
The ability to utilize the ALT keys to access any button or command on the ribbon greatly improves productivity on the PC versions of excel. Implementing this feature on the Mac version of excel would be greatly appreciated.
249 votesThank you all for all of your comments and votes supporting this suggestion. We are now in the final planning stages towards starting the development of this feature.
Steve [MS Excel]
-
Make available the forecast tool since that is needed for several statistical analysis
The forecast tool is fully available in the Windows version. Its absence actually limits various processes that are so important from financial and statistical point of view. Please look into this and try including it in the future.
190 votesThanks for this suggestion. The FORECAST.ETS functions are available in version 16.x of Excel for Mac. We will continue to monitor this suggestion and prioritize it as appropriate with the other suggestions here.
Steve K [MS Excel]
-
A better Name manager
Dear all,
What I love, please read this a need, is a better Name manager.
The size of the list is way to small. If you work a lot with names, then you get longer names which are not easy to select.
Also would like to see an easier way to replace, rename and exchange Names and references. When I make a Template sheet with names/reverences and want to make multiply copies bij code or manualy, its a crime to change or update the Name.184 votesGood news! We are planning to improve the Name Manager in Excel for Mac. Thanks for your support of this request.
We’ll be sure to provide an update as we make progress toward releasing this feature.
Steve [Microsoft Excel]
-
fuzzy lookup for Mac
Fuzzy lookup for Mac
It would be great to have fuzzy lookup add-in for Mac.
174 votesThanks for all your comments and votes supporting this suggestion. It would be very helpful if you would add more information about how you’d like to use fuzzy lookup in Excel.
Thanks – Steve K [MS Excel]
-
Support Internet Query Connection (.iqy files)
It would be helpful for Excel to Mac to support internet query connections.
When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.
127 votesThank you for taking your time to suggest and vote for IQY support on Mac. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. Worth noting however that we are working to bring Power Query to Mac which will enable you to connect, load and shape data from multiple data sources, including SharePoint.
You may review the latest status of what Power Query functionality is currently supported on Mac here:
https://support.microsoft.com/office/7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5Guy Hunkin
Principal PM, Excel Team -
Make quick access toolbar for Mac. same as in Windows, colored icons and option to move the QAT below the ribbon
Make quick acces toolbar for Mac. same as in Windows, colored end option tu use bellow the ribbon
123 votes -
Improve Graph Drawing Performance
When scrolling (e.g. with mousewheel) and a graph that was previously outside the view area moves into the view area there is a significant delay before the graph is drawn (1+ sec). If there are several graphs there is an even worse delay.
The workbook is not complex and the same spreadsheet in Excel (for Mac) 2008 did not suffer such delays i.e. nothing to do with the volume of data or the spreadsheet - something to do with Excel 2016.
I've not tried different styles or types of graph, mine are just simple line plots based in data in…
111 votesWe are investigating the best way to improve the performance of drawing charts after scrolling, and are prioritizing this along with all the other requests here.
Steve K [MS Excel]
-
Trend line to cell
Function that references a chart and gives trendline parameters.
90 votesThis is an interesting idea, and we will consider it, but we are not planning on implementing this in the short term.
-
Bring filtering charts to Excel for Mac
Bring filtering charts to Excel for Mac.
I read about this feature here: https://blogs.office.com/en-us/2014/02/04/filtering-charts-in-excel/
But I couldn't find how to use them in Excel for Mac (16.12).
I found https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msomac-mso_mac2016/chart-filter/e5e49410-6ffc-499f-bdeb-e6f8a151bd4c which claims they are not supported. This would be a useful feature to bring Excel for Mac closer to Excel for Windows.74 votes -
Bring back the "option-click" shortcut to insert column(s), row(s), or cell(s).
Please reinstate the option+click shortcut or at least a way to customize for it. It makes my work much easier and is the only reason I've yet to upgrade. Thanks a lot!
72 votesThanks for the suggestions. We will monitor the votes on this to prioritize along with the other suggestions here.
Steve K [MS Excel]
- Don't see your idea?