My GETPIVOTDATA is not working
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel – Tables -Calculating Net Sales
Hi. I was trying to complete this class but when i changed "01" to C11, it appeared REF! Can someone explain me why?
1 answers ( 0 marked as helpful)
Hi Ana,
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!
Best,
365 Eli