Forum Discussion
Generating an Formula using concatenation in excel
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.
After downloading the workbook, right-click the file in File Explorer.
Do you see a link or button "Unblock" ?If so, click it.
And, as mentioned before, make sure that the folder containing the workbook is a trusted location for Excel (File > Options > Trust Center > Trust Center Settings... > Trusted Locations)
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?
- 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
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.
While I was using the Defined Names in my computer it was working fine but now i am trying to share the same to my team members by posting the workbook to a teams channel it is not working for others. Is there something I need to do to make it work on other Computers As well.?
On the Formulas tab of the ribbon, click Name Manager.
You'll see Evaluateλ and its definition - I copied it from PeterBartholomew1's reply.
You can create the same definition in your workbook - click Define Name... on the Formulas tab of the ribbon. You can copy/paste both the name and what it refers to.
I added a missing comma to your formula, and wrapped it in Evaluateλ.
You can do the same in your workbook.
