Autofilter Slowness
 

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

Autofilter Slowness
 

Maybe you could try turning the calculation mode to manual.



Dip wrote:

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

--

Dave Peterson

Autofilter Slowness
 

Hi Dave,

It works ! Thank you so much!

Dip

"Dave Peterson" wrote:

Maybe you could try turning the calculation mode to manual.



Dip wrote:

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

--

Dave Peterson