Scope of Names for Advanced formula environment.

Copper Contributor

I installed the Advanced Formula Environment yesterday. So I might have missed something. But it appears that it only works with names that have a workbook scope. 

If this is so, I strongly suggest that you add a switch that would allow us to work with sheet-scoped names, as well. Local names might not apply to LAMBDA, but they certainly are relevant to many other named formulas in workbooks—some of which are quite long.

1 Reply

@Charley Kyd 

It doesn't sync sheet scope names, but you may use them in formulae. In general it's better to discuss AFE issues here https://github.com/microsoft/advanced-formula-environment/issues?q=is%3Aopen+is%3Aissue