Forum Discussion
Data types "window' missing in Data tab Excel MS Office Pro Plus 2021
I'm using MS Office Pro Plus 2021 (Ver: 2210 Build: 16.0.15726.20188) 64-Bit on Win 10. Last night (11/02/22) when I closed out my Excel Stock workbook, it was operating correctly. When I opened the workbook this morning (11/03/22), the 'Stock' fields (columns) had 'Unknown' where the name(s) of the stock(s) was located. I discovered that the small 'Window' where the 'Data Types' on the 'Data Tab' should be, was missing. It was there last night and everything was working correctly. Any ideas or suggestions as to what might have gone wrong and fixes for this problem will be GREATLY APPRECIATED. Thank you.
We have the same built, but you have the 64-bit version, while I have the 32-bit version. Could that cause the difference?
12 Replies
I heard that recently Microsoft removes lambdas and like from 2021, perhaps STOCKHISTORY() as well. At least 2021 is not mentioned here STOCKHISTORY function - Microsoft Support
Now all of above works on 365 only.
HansVogelaar , could you please confirm?
My Office Pro Plus 2021 is acting like it has reverted to an earlier version of Office. The function 'STOCKHISTORY' isn't recognized, along with several other stock data functions. But, when I checke it's version, once again, I get get this :
BTW...Is anyone else having this problem?....Or, is it just me?
- It appears that you may be correct, but I can't find any reference to it being removed. I'll keep searching. Thank you.
- I just finished re-installing and it did not correct the problem. Guess I'll give MS Support a try. Thanks everyone.
