0

I have a table in my Excel-Workbook named "Year".

Using the formula =YEAR(A1) returns an reference error. Excel thinks I want to reference the table "Year" instead of the function. The table overwrites the built-in function YEAR .

Does somebody know how to "tell" Excel that my Formula wants to reference the function and not the table?

Thanks in advance :)

hendrik
  • 11
  • 2
  • 2
    Asking the obvious, but why can't you rename the table? – BigBen Apr 18 '23 at 14:36
  • @BigBen The table sits within a workbook with many different use cases and I am simply not sure if renaming the table destroys some behaviour somewhere else. – hendrik Apr 18 '23 at 14:42
  • I highly doubt it. – BigBen Apr 18 '23 at 14:43
  • @BigBen Well probably. If I would have to guess I also would think it wont destroy anything. I thought maybe somebody has a solution for it though. But maybe I just have to do it and hope it doesnt cause too bad errors (if any) – hendrik Apr 18 '23 at 14:50
  • 2
    Solution: don't shadow inbuilt function names. – BigBen Apr 18 '23 at 14:55
  • If you rename the table, all the references will update to the new table name, unless you've got some referenced in a closed workbook. You can always just name it to "YearTbl" – Kairu Apr 18 '23 at 23:31
  • @Kairu okay yeah the workbook totally stands on it’s own. That resolves my fear that it could cause any errors! Thank you for pointing that out – hendrik Apr 20 '23 at 09:05

0 Answers0