Hello,

I am trying to insert a pivot table that will not load completely. First I need to 'remove duplicate data' from the E column (Sales Docs), this works okay but when I go to insert the pivot on a separate sheet it will not load all of the details beyond a certain point. Help!

Thank you,

LDCopy of Hard Goods and Freight Report 10 13 - 10 20 2014.xlsx