Forum Discussion
ChristyM22
Dec 16, 2021Copper Contributor
GetPivotData does not autofill
Hello all, I have searched and have not been able to find any other instance of this happening. I am learning how to use GetPivotData (GPV) and every reference says that if I type = and then click ...
Martin_Weiss
Dec 17, 2021Bronze Contributor
Hi ChristyM22 ,
you are right, if you have turned on the option "Use GetPivotDate functions for PivotTable references" in the Excel options, than it should generally work.
But it works only, if you click on a value field in your pivot table. If you try to do it with a row or column field, it won't work.
Maybe you can upload a screenshot or sample file, so we could better understand the issue.