This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm encountering an issue with saving Lambda functions in Excel's Name Manager. Previously, I successfully defined custom functions using Lambda within Name Manager in file A (e.g. "SCELL" function as seen Image 1).
However, I am now unable to replicate this in new workbooks (e.g., file B). As shown in Image 2, I attempt to define a new function in Name Manager using a previously successful Lambda function.
Despite clicking "OK," and return to Name Manager dialog box, the function disappears from the Name Manager (Image 3). This issue seems specific to new workbooks, as file A continues to function normally.
This problem significantly hinders my workflow. Any assistance in resolving this issue would be greatly appreciated.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Answer accepted by question author
See if any existing add-in is creating an issue. You can start with repair first though. Try all these steps from here - Excel not responding, hangs, freezes or stops working - Microsoft Support
I appreciate your assistance! While I managed to resolve the issue by modifying the command used to create the function (I'm still unsure why it worked in one file but not the other), your guidance introduced me to a valuable debugging tool in MS. Thanks for expanding my debugging toolkit!