Last answered:

07 Nov 2022

Posted on:

29 Nov 2021

0

Getpivotdata- filling a blank sheet

Hi, please whenever i try to fill a blank sheet from the pivot table using the getpivotdata function it keeps returning a reference error. I've tried fixing it but it doesn't seem to work. Please someone help out. Thanks

8 answers ( 0 marked as helpful)
Instructor
Posted on:

29 Nov 2021

0

Hi Roman,
Good to hear from you.
It might be the case that automatic creation of GETPIVOTDATA isn't enabled in your version of Excel. You will have to ajdust your settings.

Here's how to do it:

  1. Select a cell in your pivot table
  2. The PivotTable Tools tabs will appear, select the Options tab.
  3. Click the drop down arrow for Options.
  4. Then select the Generate GetPivotData command; this will turn on the feature.
  5. Please let me know if you need additional assistance
Posted on:

29 Nov 2021

0

Hello, it's checked already, but still getting same error. I guess there's something i'm not doing right.

Instructor
Posted on:

29 Nov 2021

0

Do you want to share a few screenshots? Thanks

Instructor
Posted on:

29 Nov 2021

0

Please send me a screenshot of the pivot table you want to link to and of the error message you receive.

Posted on:

30 Nov 2021

0

imageimage

Instructor
Posted on:

30 Nov 2021

0

Hello,
Did you write this manually? The idea is to start creating a formula and link to any of the cells of the pivot table.
In the formula that you've typed you have 'ferrroro' instead of 'Ferrero'.
Best,
Ned

Posted on:

01 Dec 2021

1

Hello good day, yes i wrote the formula manually, would make corrections to that, Thanks

Posted on:

07 Nov 2022

0

Yes.. I am accept

Submit an answer