Forum Discussion

rimah1555's avatar
rimah1555
Copper Contributor
May 07, 2024

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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    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?
    • SergeiBaklan's avatar
      SergeiBaklan
      MVP

      JKPieterse 

      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.

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor

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

Resources