Lambda Bugs

I want to close the loop on this. I've now been running with the macro solution for a little over two weeks. It seems to be the best solution for me. I usually need to run it no more than once a day. Some days I don't need it.

To make it easier for people, I've posted the code below. It's the same as Mohit Bhatia2's except that I've added in provisions to carry over any comments that have been added to the lambda name. 

Sub LambdaRefresh()
    Dim nm As Name, formulaText As String, comment_txt As String
    Dim EvtState As Boolean, ScrnUpd As Boolean, CalcState As XlCalculation

    On Error Resume Next
    EvtState = Application.EnableEvents
    ScrnUpd = Application.ScreenUpdating
    CalcState = Application.Calculation

    If Not EvtState = False Then Application.EnableEvents = False
    If Not ScrnUpd = False Then Application.ScreenUpdating = False
    If Not CalcState = xlCalculationManual Then Application.Calculation = xlCalculationManual
    ' Loop through all named ranges in the workbook

    For Each nm In ActiveWorkbook.Names
    ' Check if the name refers to a formula and starts with =LAMBDA(
        If nm.RefersTo Like "=LAMBDA(*" Then
            formulaText = nm.RefersTo ' Store the current formula
            comment_txt = nm.Comment
            
            nm.RefersTo = formulaText ' Reassign it to refresh
            nm.Comment = comment_txt
        End If
    Next nm

    Application.EnableEvents = EvtState
    Application.ScreenUpdating = ScrnUpd
    Application.Calculation = CalcState
    On Error GoTo 0
End Sub

Hopefully the lambda bugs can be addressed by MS because needing to use a workaround like this is not a best practice.