+ Reply to Thread
Results 1 to 3 of 3

Slow macros on Excel 2013

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    58

    Slow macros on Excel 2013

    Hi,

    I have a workbook containing a system of macros that I have been developing for several years. The macros work well on Excel 2003 and Excel 2010. On Excel 2013, on the other hand, they sometimes work ok, and sometimes work unreasonably slowly.
    I don't intend to bother anyone with my code because it's very complex. I do have one question:
    I noticed that when I open the task manager during run (without doing anything inside the task manager), it often "releases" the stuck macro and causes it to run properly.
    Does this give anyone an idea why my macros work slowly on Excel 2013 and how they can be improved?

    Thanks,

    Chen

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Slow macros on Excel 2013

    One possibility is if your code protects and unprotects sheets frequently, this will slow things down considerably due to the new algorithms that Microsoft uses to increase security in Excel 2013.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    08-12-2013
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    58

    Re: Slow macros on Excel 2013

    Thanks for the response.
    The code does not alter the protection status of sheets.
    I do believe that there is some modification specific to Excel 2013 that causes the slow-down.
    I hope to find out what it is, and maybe find a way to bypass it.

+ 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. Replies: 2
    Last Post: 02-10-2015, 08:38 AM
  2. Slow Screen Tips on Excel 2013 - HELP!
    By jcr7u in forum Excel General
    Replies: 1
    Last Post: 07-30-2014, 11:29 AM
  3. Sheets currently terribly slow in Excel 2013 (UDF's)
    By denpries in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-10-2014, 01:03 AM
  4. Macros running slow in Excel 2013
    By lgolf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2014, 12:56 PM
  5. Excel 2013 slow and stalling when using filters
    By jdb4370 in forum Excel General
    Replies: 3
    Last Post: 10-30-2013, 11:40 AM
  6. Replies: 0
    Last Post: 09-20-2013, 11:15 AM
  7. [SOLVED] I cant see my macros Excel 2013?
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2013, 03:47 AM

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