Excel Hangs while filtering
 

I am using MS-Excel-2007, and My excel file contains approx 2 lac of data,
and the file hangs a lot when i filter out data from it, or do any kind of
operation. what are the probable reason for that.
The configuration of my Laptop is Celeron 1.8 Ghz, with 2GB Ram.

Excel Hangs while filtering
 

I would try turning calculation to manual first. Then see if the autofilter
works ok.

Database_Aforeserve wrote:

I am using MS-Excel-2007, and My excel file contains approx 2 lac of data,
and the file hangs a lot when i filter out data from it, or do any kind of
operation. what are the probable reason for that.
The configuration of my Laptop is Celeron 1.8 Ghz, with 2GB Ram.

--

Dave Peterson