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 ...
Was thinking it’s possible it’s because I specified a range in one of the formulas without specifying the sheet. However, I don’t think I did that anywhere. This is a very frustrating bug, assuming it is one and seems to be affecting other aspects too.
Do you happen to run Advanced Formula Environment? That's the only cause I can think of at the moment. This bug is odd because the Lambdas are stored as named items in Workbook.xml which is not copied when a sheet is copied. Another Sheet[#].xml file is created in the zip package. The sheet xml files contain constants and formulas but no defined names.
- I do not, I just make them as normal.