Excel new formulas

Copper Contributor

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
Looks 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?

@Jan Karel Pieterse 

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.

@Sergei Baklan I found a Microsoft page stating Lambda was part of Excel 2021, but perhaps it is outdated? I misplaced the url unfortunately.

@Jan Karel Pieterse 

It was at the beginning, that's for sure. But not now I guess.