Forum Discussion
Data Type Stocks not working in Excel 2019
Thanks. however I do not get those options when I insert column. I also do not see the little "house icon" to left of the companies (ie. Microsoft)
Guido2020 Please have a look at the attached article.
It suggests that these data types are not available on Excel 2019. You may have been able to set the format but you can not pick attributes from a field list. When I open your file, being on Office365, I can see that the cells are of the Stock data type and I can see the field icon and pick the different attributes of the stock.
- OH WOW.... I bought the upgrade to 2019 to have update STOCKs for my portfolio and now MICROSOFT didn't tell us that STOCK update tools don't include?! Not cool at all... Gonna refund the money. SMH
Riny_van_Eekelen Actually, Excel 2019 does (did) support data type Stock. I purchased Office 2019 Home and Business just for that reason. I installed Office 2019 and registered it. I then created a spreadsheet with my stock portfolio and made the stock symbol column data type Stock. It changed the ticker symbols stock names and added the house icon to the left. I was able to add columns for .price and other things. I created a macro that would refresh the prices automatically. I ran this a few times each day for a week. Then, the Stock and Geography buttons disappeared from the Data ribbon and all the stock type fields now read #VALUE!. I have tried for several days now trying to get it back. From the high number of articles about the problem that I found on Bing it seems to be a universal issue.
Hummergeezer That is REALLY sucky that Microsoft would take away functionality which existed in an earlier product just to promote gravitation to their current product for the sake of revenue generation. I liken this to an auto manufacturer coming to your house and removing a feature from your vehicle then saying "We're allowed to do so via the EULA. Sorry. Not sorry."
Really SH****, Microsoft.
Any idea if Microsoft have plans on adding Stocks data type support for Excel 2019 as I am also having similar behavior and probably many others?
rlabatia Unfortunately, I do not have the answer to your question.
Thanks for your help.
That makes sense.Riny_van_Eekelen
