Share via

Lambda for Excel 2021

Anonymous
2024-05-14T17:48:27+00:00

Just wondering when the custom function "LAMBDA" will be available for Excel 2021? Currently using: Microsoft Office Home and Business 2021 (Microsoft® Excel® 2021 MSO (Version 2404 Build 16.0.17531.20152) 32-bit). From what I've found so far it's only available on Microsoft 365?

Thank you!!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2024-05-15T09:01:22+00:00

    It will display whatever values it last calculated until a recalculation occurs, and then a #NAME? error will appear (as with any functions that don't exist in older versions).

    I couldn't tell you if it will be in the 2024 version.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-05-14T21:11:33+00:00

    Ok. But is it available on any desktop versions (like the latest 2024) if I would upgrade or only for 365 excel? If i would switch to 365 and start using this function, what will happen when a non 365 user or someone with excel 2021 and older opens the file? I'm assuming it won't work or display the information correctly?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2024-05-14T17:57:36+00:00

    It won't, to the best of my knowledge. Static (i.e. non-365) versions don't really get feature updates.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments