Pivot Table Problem w/ External Data Source
Posted by Marcie on February 27, 2001 11:53 AM
Due to a rather large file (>65535 rows), I've had to use an external data source (MS Query) to import .csv text data into a pivot table in Excel. When the data is read into Excel and the report is produced, one column is showing inaccurate results. The dollars are off by a bit. The data in the .csv file is correct, but MSQuery seems to be doing something to the data in this one field. If I take a subset of the data and import it into Excel without going through Query, I get correct totals. Can anyone help?