Excel VBA massive performance drop likely related to Windows version

[Windows 11]

Hi, I run into a strange issue with an excel vba macro and could not find any really helpful hint on forums.We deal with a quite complex excel file and a macro which loops through up to 500.000 records, 150 columns accross multiple sheets. The macro usually took around 10 mins to complete on my old laptop (Microsoft Surface 8). After migration to a new Microsoft Surface Studio 2, the same macro takes hours to finish.The office versions are exactly the same. Same excel sheet, running at the same time on both devices without any other backend processes and the huge performance difference appears

Continue reading...