Forum Discussion

bgaspers's avatar
bgaspers
Copper Contributor
Nov 13, 2021

LAMBDA malfunction with HYPERLINK

I'm running into an odd malfunction using LAMBDA to encode a hyperlink function. This function:   LAMBDA(JumpRange,DisplayText,HYPERLINK(MID(CELL("filename"),FIND("[",CELL("filename")),(FIND("]",CE...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 14, 2021

PeterBartholomew1 

Yes, actually that's not about lambdas themselves. That's about name manager and environment for the lambdas.

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Nov 15, 2021

SergeiBaklan 

The interesting thing is that, in the past, I used Name Manager to access the calculation engine because it was more effective than the worksheet.  It could access the EVALUATE macro command and perform array calculation flawlessly without having implicit intersection cripple the calculation.

 

In this situation the position is reversed; hyperlinks on the sheet work whereas they fail as Named formulas.  My partially thought through idea was that hyperlink processing is not a function of the Excel calculation engine but something separate linked to document interfaces.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 15, 2021

    PeterBartholomew1 actually we may consider that as a bug. Perhaps in lambdas environment it will be found another way for deploying functions; or name manager will be improved to meet new realities; or we will live with that.

Resources