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?
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
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 - Retired Excel/VBA Consultant
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
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.
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
Thanks for the rep.
Difficult to generalise. Can you share the code and, ideally, a sample workbook? Someone may be able to help optimise the code.is there a way to better identify the root cause
i use the following code a few times in my program.
Please Login or Register to view this content.
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.
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?
i use this because this is what i found to work. perhaps i am not using it correctly. Any suggestions?
I mean why do you use it repeatedly rather than once?
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?
Generally yes - you just run it once at Workbook_Open.
So for instance, you can put this into the ThisWorkbook module:
Cheers,Please Login or Register to view this content.
berlan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks