If you have the choice: Use Windows instead of macOS for your calculation.Avoiding the SUMIFS formula for lookup also cuts the calculation time by half.The biggest impact on the calculation time is easily achieved: Switch your computer to the region “English (USA)” (if not done yet).We measured which tips actually increase the performance of Excel. More surprisingly, the difference seems to come up only under Windows.Ī possible explanation could be that Excel first translates the formulas into “English” before really calculating them. 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.
0 Comments
Leave a Reply. |