Pivot Table won't Get 'r done

  • Thread starter Thread starter clr
  • Start date Start date
C

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
 
CLR wrote in ...excel.programming...11/26:
Without getting too verbose....
....in XL2k, but the data cannot be trusted because it is incomplete.
Click to expand...
Not verbose enough.
 
Back
Top