Forum Discussion
Prevent Name Manager From Duplicating LAMBDA Formulas
Hi! I've been utilizing LAMBDA custom formulas, and one issue I've encountered is anytime I make a new sheet, or duplicate one, even if the Scope is set to "Workbook", Excel automatically creates a ...
Bizarre! I was thinking the same, but realized all of my formulas specified tables. Also, getting different results doing the same exact thing of you is super strange. Anyone I should reach out to?
That might be it. If your Lambdas have in-built references to Tables, each time you copy the sheet, you will generate new tables and hence a new copy of any Lambda function that works off the new Tables.
If that is the case then you could avoid the issue by ensuring that all references appear explicitly as arguments of the Lambda function rather than within its formula. A useful technique is to use
= LAMBDA(table,
LAMBDA(parameters,
Calculation involving table and parameters
)
)(Table1)(paramVal)If you named the Lambdas, the Lambda that has the Table as a required argument should not replicate.