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
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:
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
,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