Prev: is it possible to insert a pdf document into a excel worksheet
Next: Counting dates within a range
From: Kelli Kelli on 27 Apr 2010 10:55
I am creating a pivot table from an access database containing 896426
records. The issue I am running into is that on one of the fields the pivot
table is only pulling in one of two values, but the access table does contain
the second value. When I click on the arrow associated with that field it
does not contain the second value either. Is there somewhere else in the
settings this value could have been lost?

From: Jim Thomlinson on 27 Apr 2010 14:44
Perhaps try
Drag the field off the table
Refresh the table
Drag the field back on.

With pivot tables you need to let us know which XL version you have. pivot
tables changed in XL2002 and 2007 is a bit different also.
--
HTH...

Jim Thomlinson


"Kelli" wrote:

> I am creating a pivot table from an access database containing 896426
> records. The issue I am running into is that on one of the fields the pivot
> table is only pulling in one of two values, but the access table does contain
> the second value. When I click on the arrow associated with that field it
> does not contain the second value either. Is there somewhere else in the
> settings this value could have been lost?
>
 | 
Pages: 1
Prev: is it possible to insert a pdf document into a excel worksheet
Next: Counting dates within a range