Advanced formula environment: suggested improvement to UI

The Advanced Forumula Environment is awesome. It, along with changes to formulas such as LET, LAMBDA, and dynamic arrays have completely transformed Excel into something much more powerful and usable. So please take this out of the garage and put it out on the street as soon as possible.

 

The addition of modules is also a welcome addition. I can create many tailored functions that help enormously in building more helpful views of data more quickly.

 

The problem now is maintainability. I have a number of different spreadsheets each with different queries for related but different purposes. Each of these have to do many of the same things with the data and so can use the same functions. To do this, a way is required to provide common functions in a module or set of modules that can be shared among different spreadsheets. Cut and paste is available, but that's pretty clunky and I have to know which spreadsheets to go to and then manually go to each one and update each module by pasting over the new version. I don't have access to GitHub and I shouldn't have to have yet another account to pay for just to store a few modules that apply only to these related spreadsheets. And even that seems like it's an import, not a reference to central definition.

 

Excel already has the ability to reference data from other workbooks, and simply being able to do the same with modules would solve this problem in a stroke. Even just being able to have the modules saved as plain text files externally to reuse would be awesome. Then those files could then, if desired, be managed by a source control system. I have access to a subversion repository and possibly a GIT repository as well so being able to version them would be awesome, and then make them easily shareable within the company.

 

Seems like a number of things are happening with the Advanced Formula Environment, and hopefully many great things are coming, and I'm loving it. For me the greatest bottleneck at this stage to leveraging all of that awesomeness to it's fullest is the maintainability of modules. After that, the sky's the limit.