Hi, I have to filter 200,000 lines of data on 2 columns out of 10 columns. The criteria is filtering on 10 items in column 1 and 8 items in column 2...this is fine to filter, no troubles there. However, when I want to unfilter both columns Excel freezes up every time without fail..... I will be receiving different data every week but set up in exactly the same way...can anyone suggest another option in place of filtering..