Jul 18 2020 06:56 PM
Hi everyone:
I'm having a problem with the new function LET.
I created a formula that writes down number's values to letters. For this, I assigned 40 names to formulas in the function. Initially, it worked perfectly, but whenever I copy the formula (in current or a new workbook), close and reopen the file, it's triggering an error. The formula disappears and leaves only the last calculated result in the cell.
If anyone knows what happened, I'd appreciate any tip.
Kind regards,
Ricardo
Jul 19 2020 09:49 AM
Looks like a bug, I'd suggest you to send a frown through File->Feedback.
By the way, number to text formula with LET() you may find in discussion here https://techcommunity.microsoft.com/t5/excel-blog/announcing-let/ba-p/1233572
Aug 21 2020 09:31 AM
Hi @Sergei Baklan:
Thanks for your reply!
I went through the number to letter formula in the discussion and found it very helpful!
I rewrote mine (for Spanish numbers) in a similar way, but I keep getting the same error.
I already wrote to Excel Feedback and I am still waiting for their response.
Sad not to be able to enjoy the formula.
Aug 22 2020 01:07 PM
Perhaps you may submit the file where this function returns an error, it'll be easier to check what is wrong.
The only point, from the time of publishing abovementioned sample of the forum there was introduced the change in function - it doesn't support dots within names any more. Other words, with name as H.txt you'll have an error, use Htxt instead or any other name without the dot. Correct formula is in attached file. But that's another issue, not as in initial post.
Aug 22 2020 02:37 PM
Hi, @Sergei Baklan:
Just tried to open the file you sent but I get the same error.
I'm attaching my file, so you might want to check it out.
Thank you!
Aug 22 2020 03:46 PM
Thank you. Your formula disappears if open the file, but I was able to reproduce the issue. Will try to play with initial formula.
Aug 26 2020 02:58 AM
SolutionFor your information, I also sent a frown. People at Microsoft can reproduce the bug, hope will be fixed one day.
Please note this function is in Beta mode, that means bugs could appear in some scenarios, plus function behaviour on time of general availability could be slightly different from what we have now. That's normal process, so far we use the function (as any other beta ones) on our own risk, even if such risk is relatively small.
Aug 26 2020 09:27 AM
Thank you very much, I hope they can find what's going on. I know there is a risk, but that's why we are Insiders, to help out looking for issues like this one.
Aug 26 2020 02:58 AM
SolutionFor your information, I also sent a frown. People at Microsoft can reproduce the bug, hope will be fixed one day.
Please note this function is in Beta mode, that means bugs could appear in some scenarios, plus function behaviour on time of general availability could be slightly different from what we have now. That's normal process, so far we use the function (as any other beta ones) on our own risk, even if such risk is relatively small.