How do I filter 50,000 rows with out frozen the screen.

  • Thread starter Thread starter Alberto Ast
  • Start date Start date
A

Alberto Ast

I have use filter and advance filter but both option freeze up the screen
with the laod I am putting on...it takes long to recover it is excel 2002
 
I think you have a resources problem. I recommend splitting the sheet into
manageable sizes, maybe four sheets of 12.5K rows, do your filtering and
recombine results on a fifth sheet, for a final filtered result.
More work, but maybe your only solution.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advance Filter 4
Controlling auto-filter with VBA 1
How do I identify range of filtered sheet? 5
Macro to copy value in field and insert it into filter 2
How to filter the QueryTable from a Web query 1
Combobox filtering 2
How do I insert a Filter range result into a ListBox 4
AutoFilter Slow problem 1

Back
Top