Forum Discussion
rimah1555
May 07, 2024Copper Contributor
Excel new formulas
New formulas released for Excel need updated versions of Microsoft. After that, I updated my Excel to use the LAMDA, VSTACK, and HSTACK, and I was able to find only the VSTACK and Hstack. The next day, to continue my work, these 2 formulas weren't available and the cells where I had already used them displayed #Name.
knowing that I am using the Microsoft Office LTSC Professional Plus 2021 and my version is 2404(build 17531.20128)
Any advice for this inconvenience, I need these formulas.
Thanks in advance
4 Replies
Sort By
- JKPieterseSilver ContributorLooks like it should be there. I'd send a frown (Help, Feedback, I don't like something) and then try to see if there happens to be an update for Office. If not, you could try a repair option on the installation of Offce?
My guess was these functions are not available for 2021, aren't they? They are within the code and was opened for a while, but were closed. However, I have no 2021 to check.
- JKPieterseSilver Contributor
SergeiBaklan I found a Microsoft page stating Lambda was part of Excel 2021, but perhaps it is outdated? I misplaced the url unfortunately.