Excel 365 Formulas - How to save LAMBDA function permanently for all existing and new files

Question

Every time I launch Excel365 with my main add-in already running, I would need a global solution.

In my add-in, I created a number of LAMBDA custom functions that I would like to make available globally, not only for the current workbook. Can it be done? The formulas are not available even though I tried to save a workbook with the definition as an add-in (.xlam). They don't appear to be an add-in option when. All is well and running while I'm in the add-in parent file on the desktop. The Lambda(s) and the defined namespace, however, vanish whenever I publish the file back for you to use as an add-in.

Answer 1

Try creating a template for excel to load when it is opened.

Customizing how Excel starts so it utilized the template.