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...
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.