Advance Filter in Excel 2007 is locking up
I have a large database - (76K+ records and growing) and am having trouble running the Advanced Filter. It often locks up. Most of the time I have to save and close the spreadsheet every time I change my critera and want to run another filter. Sometimes
it won't run at all.
I've been told I need a more powerful PC and I've also been told that Excel 2010 solves this problem.
Unfortunately, I work for state government and neither of the options are currently available to me.
Does anyone have any suggestions to solve my problem?
Solutions to the Problem Advance Filter in Excel 2007 is locking up
Download SmartPCFixer for Free Now
Does the issue occur with all Excel files or a particular file?
Try creating a test database and check if issue persists.
You may also try re-saving the file using the Save as option on a different location and then check how it works.
You may also check how Excel works in safe mode.
To do that, close Excel.
Click on Start – All Programs – Accessories – Run, and in the open box type in excel /safe and hit ok.
(Note: There is a space between Excel and /). Once Excel is open, click on File ->Open and open the file causing the issue.
If Excel works in the safe mode, try disabling the Add-ins associated with Excel and check.
Refer to the section “A COM add-in is causing problems“ from the following article:
http://support.microsoft.com/kb/919196
Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.
Recommended Method to Repair the Problem: Advance Filter in Excel 2007 is locking up:
How to Fix Advance Filter in Excel 2007 is locking up with SmartPCFixer?
1. Download Error Fixer. Install it on your computer.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed
Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Solution to Error: adding a page border to my document,[Solved] After installing 'ezcap digital ATSC TV stick' using key gen, get blue screen error \"DRIVER_IRQL_NOT_LESS_OR_EQUAL\",Troubleshooting:Adobe Reader question (not working)....In the right place? Error,Troubleshoot:Adding superscript button to quick access toolbar Error,Solution to Error: adobe flash player keeps flashing at the bottom of my screen,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded