Forum Discussion

Copper Contributor

May 12, 2020

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

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 [E...

excel

Formulas and Functions

office 365

Abiola1

MVP

May 12, 2020

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

lhp007
Copper Contributor
May 13, 2020
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)