Feb 16 2022 04:09 PM
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.
Feb 17 2022 12:20 AM
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