Get Pivot data not reading some cells

F

Fawn Lagimodiere

Hi

I have a pivot table that I use getpivot data to get the results.

When I copy down formula referencing to the correct cell the data doesn't
read on some cells.

eg

Column A Column B Colmun C
E12546 Dec 100
E14556 Dec 500
E56894 Dec 50

my get pivot will reference Column A

E12546 will not read with the getpivot formula but E14556 and E56894 will
produce the results.

Not sure if there is a formatting issue with the raw data.

Any help is appreciated.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getpivot data not referencing properly 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Blank Cells 2
Need Help with a VBA subroutine 0
Playing back a Pivot Table macros 2
Pivot table - show monthly data based on start/end date data 0
General Question 0
Pivot Table Data Aggregation 0

Top