A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Missing values from a pivot table field



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2010, 03:55 PM posted to microsoft.public.excel.worksheet.functions
Kelli[_3_]
external usenet poster
 
Posts: 2
Default Missing values from a pivot table field

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?

  #2  
Old April 27th, 2010, 07:44 PM posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson
external usenet poster
 
Posts: 2,641
Default Missing values from a pivot table field

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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.