Excel Hangs while filtering

  • Thread starter Database_Aforeserve
  • Start date
D

Database_Aforeserve

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.
 
D

Dave Peterson

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

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

Dealing with the error: unable to filter on excel hc home school 0
A couple questions BEFORE using Office 365 0
excel found unreadable content' error is coming while opening xlsx file 0
'excel found unreadable content' error is coming while opening xlsx file 0
2007 slow vs 2003 and it crashes? 6
excel external data range "failed to refresh" 0
excel external data range failed to refresh - second try 1
Excel 2007 always Hangs when opeing BIG files!!!! Help 0

Top