+ Reply to Thread
Results 1 to 4 of 4

Excel 2013 slow and stalling when using filters

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Olathe, KS
    MS-Off Ver
    Excel 2013
    Posts
    2

    Excel 2013 slow and stalling when using filters

    Thank you in advance for your help.

    Problem

    When filtering columns (filtering for a words like “earplug” or “earplug plus cord” ) on an Excel 2013 file 75% of the time the program stalls for 30 seconds to 2 minutes while filtering, the mouse cursor spins, the screen turns white, I see a brief message saying “not responding” and then it comes back to the spreadsheet and I am able then to filter. The other 25% of the time it works well.

    Some background.

    I only use two files with filters, this happens on both.
    I am using a new HP Compaq Pro 6305MT desktop computer with a ASM A6-54008 with Radeon HD Graphics 3.60 GHz 64 bit
    I am using Excel 2013 locally via Office 365 on Windows 7.
    Upgraded to 12MG RAM from 8.
    Largest file in question is 4.98 MB
    Both files are .xlsx
    375 gb of 457 gb is free on the hard drive.
    The problem started before using Office 365 while using Excel 2010. IT upgraded me to Office 365/Excel 2013 form Excel 2010 to see if the new version would fix it. I did not have this problem on Excel 2003.
    I do not have this problem on my other laptop computer, and a coworker does not have the problem on their computer either.
    The largest spreadsheet goes to column AF and has 28,000 Rows
    There are no formulas or macros in the spreadsheet.
    Problem continues in Excel Safe Mode
    Saving the file to my desktop does not help.
    IT has checked my system for a process that should not be running and say I am OK.
    Copying and pasting the file into a new sheet does not help.
    We have re installed Office.

    Any suggestions would be appreciated.

    Thanks

    Dave

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel 2013 slow and stalling when using filters

    Have you tried running a cleanup utility like Ccleaner from Piriform? http://www.piriform.com/

    They have a free version than you can try.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    10-29-2013
    Location
    Olathe, KS
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Excel 2013 slow and stalling when using filters

    Newdoverman, Yes, I did do that yesterday, forgot to add it to my list. Thank you!

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel 2013 slow and stalling when using filters

    The driver for the video might have the ability to give higher performance to selected programs. This is found under Power of the Vision Control Center.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data Filters Running Very Slow
    By Jokeyjok in forum Excel General
    Replies: 17
    Last Post: 07-02-2014, 04:54 AM
  2. excel 2013 and autocad 2013 LT
    By drailed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2013, 03:05 PM
  3. Replies: 0
    Last Post: 09-20-2013, 11:15 AM
  4. Link Excel 2013 to Word 2013
    By drosen99 in forum Word Formatting & General
    Replies: 20
    Last Post: 02-26-2013, 08:20 PM
  5. Scheduled Programs - Personal Macro Workbook Dialog Stalling my Program
    By CriticalBill in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2012, 09:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1