Pivot

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SD - 23 May 2008 14:23 GMT

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

Reply to this Message

Bernie Deitrick - 23 May 2008 19:40 GMT

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

> Hello All,
>
[quoted text clipped - 9 lines]
> thanks
> Saurabh

Reply to this Message

SD - 26 May 2008 10:43 GMT

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

Reply to this Message