Forum Discussion
UNIQUE, FILTER function no more available
The exact same thing happened to me. This afternoon, 2/21/2020, I was working on my spreadsheet using the new dynamic arrays. I closed the files to take a short break. When I reopened the files, the dynamic arrays were gone. Formulas such as =UNIQUE( were replaced with =_xlfn.UNIQUE(. It is like my version of Excel 365 was taken back in time to a period before the functions were available. I have version 2001 (build 12430.20288). I noticed on the Office 365 website it mentions the latest version is 2001 (build 12430.20184) and was released on 2/19/2020. I did not notice an update. I reinstalled Office 365 but no change.
Fixed the problem. I saw an earlier post about changing languages. I went to Options -> Language and saw that it was set to "Match Microsoft Windows" and I changed it to "English." And the new functions are back.
one year later (now 21st May 2021) and I suddenly have the same problem. I have been using "unique" and "filter" in formulas for quite sometime and this morning, I open one workbook and I get the same message as you "(_xlfn.UNIQUE(_xlfn._xlws.FILTER("...
I've tried making every change in the book to the language settings (I'm on a Mac working in France but with UK English as my setting) and nothing works now. I did not change anything on the settings since stopping work last night and rebooting this morning. I was on the Excel Beta Channel but have gone back down to the "current" channel. All to no avail.
Anyone have any ideas?
No ideas. If you change no one setting, reboot and channel was changed - looks very strange. Why don't you to shift on previous channel back?
- Hey Sergei,
I am not sure to fully understand what you have written.
You write: "No ideas. If you change no one setting, reboot and channel was changed - looks very strange."
Can I interpret that you too have no idea how this could happen? You've understood what I've said and it all sounds very strange to you? You've noted that I did not change anything but after rebooting, Excel stopped working as before?
Do I also understand that you propose I "change channels" - that I go back to the "standard" channel?
If I've understood what you were asking / proposing, yes you are right. Yesterday evening, everything was fine with Excel. This morning there were a number of problems. I also thought it might be linked to a problem with the "beta" channel and went back to "standard" but that did not help.
NB: I have received a message from someone else telling me, MS may be having difficulties with my account and that I should log out and back in to see if that helps. I will try that once I finish my workday today.
Thanks for your input. I do think the problem must be linked to the "channels" because the Unique and Filter fonctions are not available everywhere and with every system. Given the fact that I have a Mac, these fonctions are perhaps still "in testing" on this platform.
