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.
-
Stock Data for new stocks not working since nov 2020
Need a fix for new stocks not showing as a valid company under stock data. Looks like issue started in November.
1 voteWe’ve updated our Stocks data to include the latest IPOs as of Dec 17th 2020. We apologize for the inconvenience of not having these available sooner. We are working on a process to provide access in a more timely manner. Thanks for your patience.
-
EXCEL For Mac needs a XML import data
There is not way to import and map XML data to excel for mac,
209 votesGood news. In the November 2019 monthly update of Excel for Mac, when you open an XML file, it will be opened as a table. If you try to use the Data menu > Get External Data > Import from Text file, it will not treat it as structured XML.
In addition to that, if you have more complex needs and you have access to Excel on Windows, you can set up a query using Power Query, and you can refresh the query in Excel for Mac. You can find more about Power Query in Excel for Mac here – https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840
The ability to open XML files as a table is included in Excel for Mac version 16.31 (191022) or greater. To update the latest version, go to Help > Check for Updates.
- Don't see your idea?