So replacing SUMIFS by VLOOKUP or INDEX-MATCH (wherever possible) might reduce the calculation time by app. We found out, that VLOOKUP and the INDEX-MATCH combination are much faster than SUMIFS. In case you are using SUMIFS as a lookup formula (which is actually quite handy) you might want to reconsider. You can still enable them later on if you need them again.
![excel for mac workbook takes long time to update excel for mac workbook takes long time to update](https://i0.wp.com/www.alphr.com/wp-content/uploads/2020/12/Screenshot-398.png)
![excel for mac workbook takes long time to update excel for mac workbook takes long time to update](https://cdn.ablebits.com/_img-blog/date-format/excel-date.png)
This should speed up your calculation immediately. 3). Scroll down, tick “Enable multi-threaded calculations” and choose “Use all processors on this computer” (no. You can switch on calculating with all available processors by going to “File” (no.
#Excel for mac workbook takes long time to update how to
How to check, how many cores are being used? When calculating a workbook, in the right bottom corner the number of processors used will be listed, “Calculating” (=only one processor) or “Calculating (4 processors)” e.g., see number 1 on the picture on the right hand side. But sometimes, it only uses one processor.
![excel for mac workbook takes long time to update excel for mac workbook takes long time to update](https://api.softwarekeep.com/media/nimbus/helpcenter/excel_compatibility_1.png)
By default, Excel calculates using all available cores.