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 votes
Thank 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:
Principal PM, Excel Team
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,243 votes
Thanks 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.
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.451 votes
Thanks 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.
Quick Analysis is available on Windows Excel 2016, but not Mac 2016 - please add.343 votes
Thanks 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]
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,433 votes
Thanks 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.
Function that references a chart and gives trendline parameters.90 votes
This is an interesting idea, and we will consider it, but we are not planning on implementing this in the short term.
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.901 votes
Thanks 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.
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?