Forum Discussion

Nathan222's avatar
Nathan222
Copper Contributor
Jan 06, 2023

Excel TAKE() Office 365 formula disappeared suddenly on Mac

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 exc...
excel
Excel on Mac
Formulas and Functions
office 365
sids291's avatar
sids291
Copper Contributor
Oct 07, 2023
I am facing the same problem. Do you get solution ?
  • Nathan222's avatar
    Nathan222
    Copper Contributor
    Oct 09, 2023

    sids291 I found that the TAKE() formula did reappear eventually after a few days. Still not sure what was the cause however.

    • sids291's avatar
      sids291
      Copper Contributor
      Oct 09, 2023

      Nathan222 Ok. So I have to wait or try randomly to fix it. 

Resources