Search : in
By :

Autofilter not working in Excel 2007.

Last answer on Nov 3, 2008 12:10:51 pm GMT Sam, on Nov 3, 2008 6:24:26 am GMT 
 Report this message to moderators

Hello,

I'm Sam from Delhi India.

I'm working in excel 2007 for last 7 months and it was working fine but for the last two months I am facing problem in excel. I'v an excel data of about 20000 rows of app. 7 mb and the problem is that the autofilter is not working properly, i.e. when I filter the data from a column it gets hanged and then I've to shut down the pc. The problem is with autofilter only however the same file working perfectly with excel 2003. And other excel files are also working perfectly in 2007 except a particular part.

Kindly help on this.

Configuration: Windows XP
Firefox 2.0.0.17

Best answers for « Autofilter not working in Excel 2007. » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Inserting an animated gif in Excel ShowInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...

1

 linksys27, on Nov 3, 2008 12:10:51 pm GMT

Hey there,

well i will provide you with a link where you will be able to do some research about that problem there:

http://office.microsoft.com/...

Reply to linksys27