Forum Discussion
Advanced Formula Environment (AFE) feedback
I tried this new feature for the first time yesterday and really love it. It takes a little while to set it up how I want it, but the potential to simplify really complex concepts is immense. Bas...
If you are referring to LAMBDA names, a simple way to distribute them is to have a worksheet that uses each of them. Then all it takes is copying the cell(s) with the lambda(s) the other workbook needs.
I am and although that will work, that is still a workaround which offers little benefit beyond what you get from creating an xlst template file to start from.
The suggestion was really to have a simple way to distribute/set this up for multiple individuals in whichever sheet they are using. That is especially important on files that come from an external source and you are not starting from scratch.
- It would be quite simple to have one workbook with all your Lambdas in a central location for everyone to access, with some simple VBA code to ease the process of copying the one(s) the user needs to his/her workbook. Or to write an add-in which checks each workbook as it is opened for presence of a pre-defined set of lambda names. The AFE cannot do that as it is an office-js add-in, which only works on one workbook and has no knowledge of other workbooks open in Excel.