Autofilter Slowness

  • Thread starter Thread starter Dip
  • Start date Start date
D

Dip

Hi,

I have a file of 2 MB that has 4,000 rows and 35 columns of mostly text data
(even numbers have been formatted as 'text'. There are 5 sheets, but 95% of
the data are in a single sheet.

When I use autofilter to sort and find data, the whole sheet is 'hung' for
around 15 seconds. Even for calculating the sum, it is the same. I tried
copying this file from the server to my computer, but the results are the
same.

If you have any suggestions, please feel free to advise.
Thanks,
Dip
 

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

autofilter with summary row 1
MS Excel 2003 - Autofilter for protected cells 1
autofilter linked in different worksheets 2
How to Sort within AutoFilter with Protection on (and AutoFilter . 1
values not appearing in autofilter list 5
AutoFilter issues 4
Autofilter only sorts the columns inlcluded (version 2007) 4
Enabling Autofilter and Sorting in a Protected Sheet 2

Back
Top