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

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


"SD" <saurabhkdas@gmail.com> wrote in message
news:5c8a2667-62ff-4781-a163-aac8a3150600@2g2000hsn.googlegroups.com...
> 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

On May 23, 11:40*pm, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:
> 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.
>

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