Excel 2013 - Document with formulas in other language


Our users have just switched from Hungarian Excel to English Excel and now they experience problems with some Excel sheets where the formula is written in Hungarian. All the cells with formulas says #NAME!.

If I change the formula to English, everything works fine. But I thought that Excel did this automatically? And is there an easy way to change the formulas to English without changing every cellformula?
Sum WumAsked:
Who is Participating?
There are no shortcuts, you will have to manually change the formulas or use vba.
Frank WhiteCommented:
The most common case I've encountered where this happen is when users copy-pasted formulas as text (e.g. from an email correspondence) into cells of a workbook in a different language.

If a Hungarian formula is saved in a workbook with a Hungarian-locale Excel, and then the Excel file sent to a computer with an English locale version (or the locale is changed), opening the file there should convert the formulas into the English format.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.