•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
MONTH() and YEAR() functions return #REF, and the "Month" and "Year" filters on pivot tables seem to be the issue.
I am trying to use the MONTH() and YEAR() functions, but whenever I type them in this specific sheet, they seem to autocorrect to "Month" and "Year" (the first structured reference option in the select drop down that appears as you type) and produce an error, even when the function option is explicitly selected. Typing "=Month" alone produces an array of dated data from elsewhere in the sheet, which seems to indicate that it's reading it as a structured reference instead of a function. The functions work normally in a fresh file (even when referencing the same data in the original file). Is there a way to indicate that is should be a function, and not a structured reference?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#Excel compatibility
#Excel alternatives
#MONTH
#YEAR
#functions
#structured reference
##REF
#pivot tables