Forum Discussion
Pivot Table Yearly Sales Report Issue
I'm currently working on creating a pivot table for a yearly sales report. However, I'm encountering an issue where, after a particular row, the year is not being recognized. This results in an error...
When I opened your file, I saw the #VALUE! errors. Looked at the first formula with the error. Saw nothing out of the ordinary. Pressed F2 and Enter to re-enter and copied it down. The problem went away.