My pivot does not show the GETPIVOTDATA functionality even though it is turned on

Question

My pivot does not show the GETPIVOTDATA functionality even though it is turned on

Answer 1

Hi @Sood, Anoop

Do you mean the "Generate GetPivotData" is ticked?

If you type "=" in a blank cell, and then select (Via mouse clicking) a value from the Values fields of the pivot table, will this function appear automatically?

If not, I suggest you check this function in other workbooks.

I also suggest you perform an online repair for your Office.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

You mean this function?

https://support.microsoft.com/en-us/office/getpivotdata-function-8c083b99-a922-4ca0-af5e-3af55960761f

Which MS Excel version & edition are you using?

You need CoPilot for, have you?