I have a pivot table that for some reason is not correctly totaling the data. When I sum the count column in the data and compare to the sum column from the pivot table - I am short. The two totals should match. Any suggestions? I copied all the data as values to see if there were formulas or something I didn't see but that didn't fix the discrepancy. What could possibly be causing this? I do not want to manually subtotal 60,000 lines of data!! I appreciate ANY help I can get!!