Jan 06 2023 02:18 PM
I started using the TAKE() (Office 365 function) in a workbook this week and it was working just fine, but yesterday it suddenly gave a _xlfn. prefix. I double checked my license and confirmed my excel license is using Office 365 and I even reinstalled Excel, but I can't even see the TAKE function in my formulas tab anymore in my desktop app.
According to the Microsoft help page this function is available in the following builds
Windows: 2208 (Build 15601)
Mac: 16.65 (Build 220911)
Web: introduced 15-Sep-2022
iOS: 2.65 (Build 220905)
Android: 16.0.15629
I'm currently running a Mac: 16.70 (Build 23010400)
Oct 07 2023 03:17 PM
Oct 09 2023 08:04 AM
@sids291 I found that the TAKE() formula did reappear eventually after a few days. Still not sure what was the cause however.
Oct 09 2023 08:11 AM
@Nathan222 Ok. So I have to wait or try randomly to fix it.