Hi,

I need some advice on Win10 speed comparatively to previous Windows version.

I have a Function to get a data range from closed workbook (see below) which being used by managers around the country to get data to perform further calculation.

I have done a speed/stress test where i loop the get data 70 times for more than 10 times . with WIN7, average time take is 2-3 minutes whilst Win10 would take between 9-11 minutes
These Are my specs on both Win 7 & Win 10
Win 7 : Intel Core i5-4300U , RAM 4GB, System 64bit, Excel Version Office 2010 Version 14.0 (32-bit)
Win 10 : Intel Core i5-6300U, RAM 16GB, System 64bit ,Excel Version Office 2013 Version 15.0 (32-bit)


Would be good if someone can answer me this question or if there is a better code to run on Win10.


Please Login or Register  to view this content.
Regards,
Lex