Forum Discussion
GetPivotData does not autofill
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.
- ChristyM22Dec 17, 2021Copper Contributor
Martin_Weiss Thank you so much! I struggle with Pivot Tables to begin with, and all of the information I found about GPD all say to "click any cell in your table". Nothing specified that it had to be a value cell. My table didn't have a value cell. I redid the table and added a value field and it works perfectly.
I only referenced a calculated column from the source table in the original.
Now I am thinking that GPD isn't the function I need for what I want to accomplish. Back to the drawing board I guess.