Pivot Table won't Get 'r done

[clr]

Hi All........

Doing a Pivot Table on a 900 row by 26 column database....however, all
fields will not come in. The Pivot Table us using 5 columns to search, and
one column summed to return a dollar amount. I've reformatted the errant
columns in the database, and resorted them, but no joy......however, when I
reformat an individual errant CELL from General to TEXT, that row comes
in........and/or, if I change the value in one of the errant cells, the
Pivot Table will bring that row in.

Any ideas would be appreciated

Vaya con Dios,
Chuck, CABGx3

 

[Herbert Seidenberg]

CLR wrote in ...excel.programming...11/26:

Without getting too verbose....
....in XL2k, but the data cannot be trusted because it is incomplete.

Not verbose enough.