Blog Post

Excel Blog
6 MIN READ

Announcing LAMBDAs to Production and Advanced Formula Environment, A Microsoft Garage Project

Chris_Gross's avatar
Chris_Gross
Icon for Microsoft rankMicrosoft
Feb 08, 2022
  November 17th 2022 Update The advanced formula environment has been updated to version 1.1. See the change log for more information.   We are excited to announce that LAMBDA...
Updated Nov 18, 2022
Version 7.0
advanced
advanced formula environment
calc
custom
custom functions
editor
environment
excel
formula
Formulas
SergeiBaklan's avatar
SergeiBaklan
MVP
Feb 09, 2022

PeterBartholomew1 , loading of names is not obvious question, at least for me. For your sample - it works without loading names into AFE

Now assume we have workbook with hundreds thousand of names, 98% percent of which are names of range and like. Why do we need megabytes of such names duplicate in AFE ?

I could agree that sync is far from perfect, at the same time not sure we know or may agree what the perfect is.