Excel issues #NAME? error when opening CSV file with formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1382377%22%20slang%3D%22en-US%22%3EExcel%20issues%20%23NAME%3F%20error%20when%20opening%20CSV%20file%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382377%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EWhen%20opening%20a%20CSV%20file%20with%20Excel%20365%20(version%202004)%20we%20receive%20a%20name%20error%20on%20the%20fields%20using%20formulas.%20These%20formulas%20are%20correct%20and%20will%20calculate%20upon%26nbsp%3Baccessing%20the%20field%20and%20clicking%20%5BENTER%5D.%3C%2FP%3E%3CP%3EThe%20CSV%20file%20works%20fine%20with%20Excel%20on%20mobile%2C%20Excel%26nbsp%3BOffice%202010%20and%202016.%3CBR%20%2F%3EAny%20help%20would%20be%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1382377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382610%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issues%20%23NAME%3F%20error%20when%20opening%20CSV%20file%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382610%22%20slang%3D%22en-US%22%3EYou%20can%20re-save%20the%20CSV%20file%20as%20a%20proper%20Excel%20Workbook.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1386353%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issues%20%23NAME%3F%20error%20when%20opening%20CSV%20file%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1386353%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3Bthanks%20for%20your%20reply.%20We%20did%20what%20you%20suggested%20but%20without%20luck.%20The%20formulas%20still%20won't%20calculate.%20However%20when%20consulting%20the%20formula%20cell%20content%2C%20we%20notice%20that%20Excel%20adds%20an%26nbsp%3B%40%20before%20the%20formula.%20(I%20attached%20a%20screen%20shot)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388769%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issues%20%23NAME%3F%20error%20when%20opening%20CSV%20file%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388769%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20some%20research%3A%20This%20is%20due%20the%20fact%20we%20are%20using%20formulas%20written%20in%20Dutch.%3CBR%20%2F%3EWhen%20we%20rewrite%20the%20formulas%20in%20English%2C%20Excel%20will%20calculate%20the%20formulas%20and%20translate%20them%20into%20...%20Dutch%20%3CLI-EMOJI%20id%3D%22lia_winking-face%22%20title%3D%22%3Awinking_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EMyst%C3%A8re%20...%26nbsp%3B%3CBR%20%2F%3EIs%20this%20a%20Bug%20or%20a%20new%20feature%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,
When opening a CSV file with Excel 365 (version 2004) we receive a name error on the fields using formulas. These formulas are correct and will calculate upon accessing the field and clicking [ENTER].

The CSV file works fine with Excel on mobile, Excel Office 2010 and 2016.
Any help would be appreciated

3 Replies
Highlighted
You can re-save the CSV file as a proper Excel Workbook.
Highlighted

@Abiola1 thanks for your reply. We did what you suggested but without luck. The formulas still won't calculate. However when consulting the formula cell content, we notice that Excel adds an @ before the formula. (I attached a screen shot)

Highlighted

After some research: This is due the fact we are using formulas written in Dutch.
When we rewrite the formulas in English, Excel will calculate the formulas and translate them into ... Dutch
Mystère ... 
Is this a Bug or a new feature?