Forum Discussion
UNIQUE, FILTER function no more available
Since today mid afternoon (21/02/2020) , all the new dynamic array function such as UNIQUE and FILTER suddenly desappear from my desktop Excel (still available for my Excel On Line). I am a Office 36...
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.
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.