Formulas in tables changes language automatically when inserting new row

Copper Contributor

I have a table where I calculate day, month and year values in other columns based on the entered date values.
I use this spreadsheet on my Mac and iPhone.
When I go back to using the document on a Mac or iPhone, the formula breaks and throws an error every time I add a new line.

Excel adds "@" at the beginning of formula than somehow translate the rest of the formula to English.

=GÜN([@[Booked On]]) turns to =@DAY([@[Booked On]])

=AY([@[Booked On]]) turns to =@MONTH([@[Booked On]])

=YIL([@[Booked On]]) turns to =@YEAR([@[Booked On]])


When I enter a date in [Booked On] Column, system returns "Invalid cell reference error"

When I copy and paste the formula from above row it returns the value I'm looking for but marks all the column with green label and returns "Calculated column formula is inconsistent" error. 


Locale settings are the same in both devices.


DAY(serial_number) MONTH(serial_number), YEAR(serial_number) formulas in Turkish are

GÜN(seri_no), AY(seri_no) and YIL(seri_no)


Ekran Resmi 2023-11-03 11.36.05.png

1 Reply


It seems that Excel might be trying to change the formulas to a different language based on the operating system or regional settings. If you are sure your settings are consistent across devices, here is an approach that might resolve the issue:

  1. Check the Formula Locale Settings:
    • Confirm that the formula language settings are consistent on your Mac and iPhone.
    • In Excel for Mac, check the language settings under Excel -> Preferences -> International.
    • On your iPhone, verify the system language settings that might affect Excel formulas.
  2. Convert to English Formula:
    • One potential solution is to use English formulas that work universally across devices. For instance, use DAY(), MONTH(), and YEAR() instead of the Turkish counterparts (GÜN(), AY(), YIL()).
  3. Check Table Options:
    • In Excel for Mac, verify the Table options for any specific language or formula settings that might be affecting the table's behavior.
  4. Excel Version and Updates:
    • Ensure you are using the latest version of Excel on both your Mac and iPhone.
    • If there's a specific issue tied to the application's version or updates, checking for available updates might resolve the problem.

If the problem persists despite these checks, it might be worthwhile to reach out to Microsoft Support or Excel support forums to address the issue. They might have specific troubleshooting steps or insights based on the behavior of the formulas.


NOTE: My knowledge of this topic is limited, but since no one has answered it for at least one day or more, I entered your question in various AI. The text and the steps are the result of various AI's put together. Maybe it will help you further in your project, if not please just ignore it.


My answers are voluntary and without guarantee!


Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.