+ Reply to Thread
Results 1 to 14 of 14

Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,435

    Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    Hi,

    I just upgraded from excel 2007 to excel 2013. I ran a macro i have been running recently in excel 2007 which took about 14seconds. After the upgrade it took about 24 seconds........i repeated it just to be sure and it really did take 24 seconds.

    Any idea why 2013 would take longer to run?

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, United Kingdom
    MS-Off Ver
    Office 365
    Posts
    1,217

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    I think it would down to the procedures you are using in macro. Any specific procedure/functions you are referring to? Protection procedures I know can take a bit more time, given added security in later Excel versions.

    But otherwise, generally optimizing the workbook is good if you haven't already. Here's a good article http://www.jpsoftwaretech.com/excel-...-optimization/

    Cheers,
    berlan

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,119

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    There tends to be a performance degradation between all versions of Excel ... as a generalisation (for discussion/debate). More functionality and features usually mean more processing power is necessary. And the implementation is not always the most efficient.

    Conditional Formatting seemed to be a bit of an issue between Excel 2007 and Excel 2010, for example. And processing that was instantaneous in Excel 2007 meant "coffee time" in Excel 2010.

    So, no surprise really. However, it may be possible to optimise the code so that it works better in all versions, although probably still slower in 2013. For that, you need to share the code in a sample workbook with some typical data.

    Unfortunately, I don't have Excel 2013 (yet) so I might not be able to test any proposed improvement.

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,435

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    I do have a couple of cases where i unprotect a worksheet and then protect it again after i am done.

    i read a couple of links after i saw your post about protect/unprotecting sheets........

    what i have not found is a soln to the problem and/or a workaround to help reduce the processing time.

    also, i am guesing at this point that the increased time is due to the protect / unprotect.........is there a way to better identify the root cause.........the reason i ask is the increased time is quite substantial.

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    Changing sheet protection is slower in 2013 as they changed the algorithm. If you can, protect the sheets once in the Workbook_Open event using the Userinterfaceonly:=True parameter. That will allow most code to run without needing to change the sheet protection again - but it doesn't allow all options to work, unfortunately, so you'll need to test if it works in your case.
    Remember what the dormouse said
    Feed your head

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,119

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    Thanks for the rep.

    is there a way to better identify the root cause
    Difficult to generalise. Can you share the code and, ideally, a sample workbook? Someone may be able to help optimise the code.

  7. #7
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,435

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    i use the following code a few times in my program.

    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    why not compare the time to execute macro on unprotected (in advance) worksheets in bot 2007 and 2013 (and comment out all unprotect/protect code)? if the time is comparable in this case, then the reason is obviously in the protection.
    If you are pleased with a member's answer then use the Star icon to rate it.

  9. #9
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    Why do you use that a few times? The point of the userinterfaceonly argument is to allow your code to run without changing the sheet protection - are you performing tasks that it can't cope with?

  10. #10
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,435

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    i use this because this is what i found to work. perhaps i am not using it correctly. Any suggestions?

  11. #11
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    I mean why do you use it repeatedly rather than once?

  12. #12
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2007
    Posts
    2,435

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    i am not sure..........i will have to review the code and figure it out........i have not used this macro in a while. but thanks for responding.

    so i only have to do it once.........is this right?

  13. #13
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    Generally yes - you just run it once at Workbook_Open.

  14. #14
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, United Kingdom
    MS-Off Ver
    Office 365
    Posts
    1,217

    Re: Just upgraded to excel 2013 from excel 2007 much slower in excel 2013 why?

    So for instance, you can put this into the ThisWorkbook module:

    Please Login or Register  to view this content.
    Cheers,
    berlan

+ 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. Excel 2013 unProtect/Protect much slower
    By cmwilbur in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2015, 11:33 PM
  2. Replies: 1
    Last Post: 12-27-2014, 11:20 PM
  3. No PowerPivot in Com Add ins Excel 2013 (Microsoft office professional plus 2013)
    By benoj2005 in forum PowerPoint Formatting & General
    Replies: 7
    Last Post: 09-18-2014, 09:13 AM
  4. Replies: 3
    Last Post: 07-20-2014, 11:46 AM
  5. Replies: 10
    Last Post: 08-20-2013, 01:02 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