We compared the region “German (Germany)” with “English (USA)”. Surprisingly, these settings seem to have a major impact on the calculation performance of Excel.Īs the difference is so huge (+400 – +500% of calculation duration), we repeated this test under the three environments of the ThinkPad, Windows on a MacBook under Bootcamp as well as Excel for macOS.
A VLOOKUP in Excel with German regional settings looks like this: Therefore Excel formulas don’t use commas for separating arguments but rather semicolon. The German numeric system uses commas as decimal character and points as thousands separator. The regional settings seem to have a big impact on the performance of Excel. We actually didn’t plan this test but rather found out by coincidence. Under Windows, the regional settings have a major impact on the calculation time of Excel.
