Need a fix for new stocks not showing as a valid company under stock data. Looks like issue started in November.1 vote
We’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.
There is not way to import and map XML data to excel for mac,209 votes
Good 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?