I am trying to programatically create a pivot table with a tab delimited
data string. The fifth column of this string is the Value field with
numbers appearing in different formats or even text. I am creating this
pivot table by dropping the string on a sheet and using the Jet driver
to populate a record set which in turn populates the pivot cache. I
need to do it this way since I overshoot the 65000 row limit for Excel.
I can successfully create the pivot table if I eliminate all formats
and text values from column 5. I want to know if there is any way for a
pivot table to handle text based values and number formats.

Thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/