Forum Discussion
Ben Kilman
Sep 28, 2022Copper Contributor
Year Function returning #REF!; not sure why
I am actually a bit embarrassed for asking this, but I've been trying for 2 days now and cannot figure out why this is happening. I'm using the dynamic tables (but this problem happens in or ou...
- Sep 28, 2022Maybe a named range called "year"?
Ben Kilman
Sep 28, 2022Copper Contributor
There are no macros in the workbook.
Detlef_Lewin
Sep 28, 2022Silver Contributor
Maybe a named range called "year"?
- Ben KilmanSep 28, 2022Copper Contributor
Thank you. That was it. I had a table named year.
I would not have thought to look for that.
Thank you, thank you, thank you...