Forum Discussion

LouisM33's avatar
LouisM33
Copper Contributor
Dec 17, 2023
Solved

FILTER function suddenly not working anymore

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

  • LouisM33's avatar
    LouisM33
    Dec 19, 2023

    No it is FILTER indeed HansVogelaar 

     

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

2 Replies

Resources