Forum Discussion
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 ...
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.