FILTER function suddenly not working anymore

[LouisM33]

Hello everyone,

I have a workbook that I've used for weeks now with FILTER() function in it. Never had an issue.

Suddenly, the results display #NOM? (Excel is in French, I suppose the translation would be #NAME?) and the function isn't FILTER() anymore it is: _xlfn._xlws.FILTER()

I've read that it seems to be a versionning issue but my Excel version is up to date:

Does anyone know the answer to my issue here? Many thanks.

Louis

[#2]

@LouisM33 

Shouldn't it be FILTRE in French?

[#3 · Accepted solution]

No it is FILTER indeed @HansVogelaar 

Changed the Language to English and then back to French, restarted my laptop and it is fixed now 🙂