Forum Discussion
Solved
Generating an Formula using concatenation in excel
Hi There, I am planning to generate a formula using concatenation operation in excel and it actually works but the only issue is it’s not executing it just gives the generated formula as output i...
This uses the XLM command EVALUATE within Name Manager where it works correctly just as HansVogelaar 's solution. With 365 the process can be taken a step further and the name can be a Lambda function.
EVALUATEλ = LAMBDA(formula, EVALUATE(formula))The sole advantage is that EVALUATEλ can be reused with multiple strings.
If they open the file in Teams, which is actually Excel for web, EVALUATE, since VBA, doesn't work. That's only to open in Desktop app within Teams, or use Office Script. Assuming everyone is on corporate subscription, Office Script is not available for consumers.
Nope we are actually syncing the files to the local folder from a teams channel and my team is trying to open it in desktop application still the formula works on my computer but not for others
That's new for me how to share Teams channel on local folder. Anyway, if people go to this local folder and try open the file without Teams, does it work?