Scope of Names for Advanced formula environment.

%3CLINGO-SUB%20id%3D%22lingo-sub-3176264%22%20slang%3D%22en-US%22%3EScope%20of%20Names%20for%20Advanced%20formula%20environment.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3176264%22%20slang%3D%22en-US%22%3E%3CP%3EI%20installed%20the%26nbsp%3B%3CSPAN%20class%3D%22%22%3EAdvanced%20Formula%20Environment%20yesterday.%20So%20I%20might%20have%20missed%20something.%20But%20it%20appears%20that%20it%20only%20works%20with%20names%20that%20have%20a%20workbook%20scope.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20this%20is%20so%2C%20I%20strongly%20suggest%20that%20you%20add%20a%20switch%20that%20would%20allow%20us%20to%20work%20with%20sheet-scoped%20names%2C%20as%20well.%20Local%20names%20might%20not%20apply%20to%20LAMBDA%2C%20but%20they%20certainly%20are%20relevant%20to%20many%20other%20named%20formulas%20in%20workbooks%E2%80%94some%20of%20which%20are%20quite%20long.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3176264%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3177304%22%20slang%3D%22en-US%22%3ERe%3A%20Scope%20of%20Names%20for%20Advanced%20formula%20environment.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3177304%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F232597%22%20target%3D%22_blank%22%3E%40Charley%20Kyd%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20doesn't%20sync%20sheet%20scope%20names%2C%20but%20you%20may%20use%20them%20in%20formulae.%20In%20general%20it's%20better%20to%20discuss%20AFE%20issues%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fadvanced-formula-environment%2Fissues%3Fq%3Dis%253Aopen%2Bis%253Aissue%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fmicrosoft%2Fadvanced-formula-environment%2Fissues%3Fq%3Dis%253Aopen%2Bis%253Aissue%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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