Forum Discussion

FredL28's avatar
FredL28
Copper Contributor
Aug 13, 2021
Solved

Function UNIQUE() keeps disappearing from the library!

Hi,

I am a long time user of Excel on Mac OS, using Office 365 and the latest Excel v16.52

For the past couple of weeks I'm experiencing the weird disappearance of the function UNIQUE() from Excel function builder.

1- First, I used the function like =UNIQUE(Table_Vuln_Current_Week[App Name];FALSE)

to return a list of application names, and it worked fine

 

2- The next day, I open the same workbook and Excel displays something like

=_xlfn.UNIQUE(Table_Vuln_Current_Week[App Name];FALSE)

it is greyed out and if I want to edit or re-enter the formula, I get a #NAME error

 

3- Yesterday I got the latest update installed and the function was working again, until this morning

If I try to create a new worksheet to run a test of this function, I get the #NAME error

 

4- I closed Excel, re-opened my work file and there it is, the formula is no longer showing the _xlfn. prefix

I use tons of formulas in my workbook and I only get this issue with the UNIQUE() and IFS functions

Has anyone encountered such weird behaviour?

 

Thank you

  • FredL28 

    It seems the issue resolves itself if I completely close the app Excel and re-launch it

    But every now and again, I get these errors and I have to close Excel and re-open the file

1 Reply

  • FredL28's avatar
    FredL28
    Copper Contributor

    FredL28 

    It seems the issue resolves itself if I completely close the app Excel and re-launch it

    But every now and again, I get these errors and I have to close Excel and re-open the file

Resources