I've got a similar problem on this. I'm running a loop to open +- 250 .xlsx files, unprotect sheet with password, copy data from each file to a master file and then closing each file without saving.

I put a timer on the macro and the process takes +- 1 minute in excel 2010 but 28 minutes in excel 2013