+ Reply to Thread
Results 1 to 2 of 2

Code takes 10 sec to run in excel 2010 but only 1 sec in older versions, why

  1. #1
    Registered User
    Join Date
    01-05-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    17

    Code takes 10 sec to run in excel 2010 but only 1 sec in older versions, why

    When the user deletes an entry in cell B2 etc it takes 10 second to finish filtering (and show all) when running this in Excel 2010 but it is much faster in Excel 2003. What is different? How do I fix it.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    01-05-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2016
    Posts
    17

    Re: Code takes 10 sec to run in excel 2010 but only 1 sec in older versions, why

    I found a fix posted by Chris Bourque on this webblog. http://blogs.office.com/b/microsoft-...practices.aspx
    Basically turning off some aspect of excel while the code is executing does the trick.
    P1awn

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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