![]() However, when using the same files as the ones used in the Work PC (which is significantly older and slower on all other tasks, and has Excel 2013), using Excel 2016, Macros now takes about 6 minutes, this is about 2 times slower, than the Work PC, using the exact same files, but, only changing the Excel version.Īssuming it was a problem maybe with the version of Excel, I tried the same Macros on my laptop, which has a Ryzen 4800h and Excel 2016. Last year, when using this Macros on this PC (can't remember if I had Excel 2016 or Excel 2013 at that time), which has a Ryzen 3800x with 8 cores and an NvME, Macros used to take about 1 and a half minutes, or 1 minute, depending on the file that was read, so, no problem there. On this Pc, Macros with current files takes about 2-3 minutes to complete on Excel 2013. This PC has as CPU an Intel Xeon with 8 cores (Z620 HP Workstation, really old) and 1 TB HDD. I created the Macros in Excel 2013, on a PC at work. I've made a Macros for sorting data from a CSV File, and put it in a normal Worksheet. Was wondering if anyone has ever had this problem, it looks like it's a problem with Excel 2016 in this PC specifically.
0 Comments
Leave a Reply. |