Forum Discussion
Problem running Excel Advanced Formula Environment
Hello, I have installed the Advanced Formula Environment on my Microsoft 365 version of Excel (Version 2204 Build 16.0) It installs successfully and shows up on my Ribbon under the Home Tab. Ho...
I am having this exact same problem. Install the addin and get this message when I try to use.
This add-in won't run in your version of Office. Please upgrade to either one-time purchase Office 2021 or to a Microsoft 365 account.
I have a M365 subscription.
Without this addin, defining LAMBDAs via the Excel Name manager is horrible, one tiny box to enter in, no line break (ALT+ENTER does not work here)
LAMBDAs are great, but still some usability problems.
This add-in won't run in your version of Office. Please upgrade to either one-time purchase Office 2021 or to a Microsoft 365 account.
I have a M365 subscription.
Without this addin, defining LAMBDAs via the Excel Name manager is horrible, one tiny box to enter in, no line break (ALT+ENTER does not work here)
LAMBDAs are great, but still some usability problems.
Please check this thread Not recognizing Microsoft 365 Account · Issue #11 · microsoft/advanced-formula-environment · GitHub on product site.
- Thanks.
That thread highlights that the Addin is fine in Excel Online and only failing in the desktop version. That is my experience also. It would be great if it worked in desktop Excel but meanwhile I can use Excel online to manage the larger LAMBDA definitions and continue to work mainly in the desktop. I think that's workable even if a tad inconvenient. Hopefully the issue gets fixed soonish.