Pivot

S

SD

Hello All,

Some sort of excel glitch here. I have a pivot and a dataset. The
pivot shows the item selected but the data is not shown. And when I
select only that particular item its all zeros. I checked my data set
and its there. Do I have to redo the pivot. I actually just pasted
fresh data over the existing pivot and refreshed it . All other data
is coming except only one of them. Is this a bug ?

any help would be appreciated .

thanks
Saurabh
 
B

Bernie Deitrick

Saurabh,

Sounds like you pasted text values over your number values. Try entering 1 into a blank cell,
copying that cell, then selecting the data cells and using Paste Special Multiply. That will
convert any text values to numbers.

HTH,
Bernie
MS Excel MVP
 
S

SD

Saurabh,

Sounds like you pasted text values over your number values.  Try entering 1 into a blank cell,
copying that cell, then selecting the data cells and using Paste Special  Multiply.  That will
convert any text values to numbers.
Click to expand...

Thanks Bernie for the help, however I did try to get this done, and
it did not work just cant get the Pivot listed item. May be I redo
the whole thing over , however if there is anything else you would
want me to try I could .. thanks SD
 
Top