Excel renames my formulas to different language

%3CLINGO-SUB%20id%3D%22lingo-sub-2964868%22%20slang%3D%22en-US%22%3EExcel%20renames%20my%20formulas%20to%20different%20language%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2964868%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Excel%20with%20Office%20365.%20The%20settings%20are%20set%20to%20the%20Dutch%20language%20and%20I%20use%20Dutch%20formulas.%20But%20somehow%20after%20re-opening%20an%20existing%20document%20Excel%20changes%20some%20of%20the%20formulas%20in%20my%20file%20to%20English%20(not%20all).%20For%20instance%20%3DXLOOKUP%20(Since%20it%20is%20set%20to%20Dutch%20I%20use%20%3DX.ZOEKEN)%20changes%20to%20%3D_xlfn.XLOOKUP.%20But%20a%20forumla%20like%20%3DIF%20(Dutch%3A%20%3DALS)%20hasn't%20changed.%20The%20new%20changed%20forumla%20of%20%3D_xlfn.XLOOKUP%20does%20not%20work.%20When%20this%20problem%20occurs%20I%20also%20can%20no%20longer%20use%20neither%20the%20Dutch%20function%20%3DX.ZOEKEN%20nor%20the%20Enlish%20function%20%3DXLOOKUP.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20mannually%20install%20updates%20for%20Office%20365%20the%20problem%20often%20is%20fixed%2C%20but%20it%20reappears%20within%20a%20few%20days.%3C%2FP%3E%3CP%3EI%20cannot%20find%20anything%20similar%20online.%20Does%20someone%20know%20how%20to%20fix%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2964868%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am using Excel with Office 365. The settings are set to the Dutch language and I use Dutch formulas. But somehow after re-opening an existing document Excel changes some of the formulas in my file to English (not all). For instance =XLOOKUP (Since it is set to Dutch I use =X.ZOEKEN) changes to =_xlfn.XLOOKUP. But a forumla like =IF (Dutch: =ALS) hasn't changed. The new changed forumla of =_xlfn.XLOOKUP does not work. When this problem occurs I also can no longer use neither the Dutch function =X.ZOEKEN nor the Enlish function =XLOOKUP.

 

When I mannually install updates for Office 365 the problem often is fixed, but it reappears within a few days.

I cannot find anything similar online. Does someone know how to fix this problem?

1 Reply

@WoutvH 

_xlfn prefix means that function doesn't exists in your version of Excel. Something is wrong with your subscription and/or installation.