My GETPIVOTDATA is not working
Hi. I was trying to complete this class but when i changed "01" to C11, it appeared REF! Can someone explain me why?
thanks for reaching out!
First I'd add the IFERROR statement in the cell, to avoid the potential error of having an empty cell (4:22) in the video.
One of the other reasons you might be getting the error is if you've not fixed all the cells correctly. You ought to add $ in C$11 and C$12.
Lastly are the years in your report of type date? That's the next thing I'd check and make them dates if they're not.
If doesn't resolve the issue you should try the formula and replacing the references step by step to see when the error arises.
Let me know if you have any further issues!