Are there any filters on the pivot table?
To remove all the filters:
Select a cell in the pivot table
On the Ribbon, click the Options tab
In the Actions group, click Clear, then click Clear All

Ed K wrote:
I have been using the same Excel workbook for 10 years, across three Excel
versions, and 2 OSs. About three times a month, I create the same pivot
table from a database (a named range) on a worksheet.
I have a brand new Dell Vista laptop with Office 2007. I consider myself an
expert Excel user. But when I create the very simple, two-column pivot table
now, the resulting table misses more than half the records in the database.
And the 100s of records it does miss are not necessarily consecutive records
in the database.

Has anyone else had this problem? Any ideas what the fix is? I guess I'm
naive, but why would a simple transition to a newer version of Excel not
work on something I haven't changed in 10 years?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html