VBA，Code在excel 2010中运行良好，在2013年缓慢且没有响应错误

Previously when running my code in 2010 excel version (Version 14.0.7165.5000), it runs in 4 minutes. (however if I run it a second time, it doesnt work) When switching to 2013 I get 'excel not responding' or it just excel hangs. The code opens a files from a directory, loads them into my excel sheet and compiles and transforms some data.Previously when running my code in 2010 excel v