Calculating (4 Threads)

[AndreaJean18]

What is the best way to handle this lengthy calculating process?

[MrShorty]

Usually one would use more efficient algorithms, reduce duplicated effort (common with single cell mega-array formulas), and eliminate programming bottlenecks. With no information about the specific steps/tasks/algorithms you are asking Excel to do, we cannot provide anything more specific.

If it will help, perhaps a few examples of others improving calculation time:
This one went from "literally a week" to 5 seconds to calculate: https://www.excelforum.com/excel-pro...lculation.html
This one employed some helper columns to reduce duplicated effort: https://www.excelforum.com/excel-for...ificantly.html
This one was improved by removing volatile functions and changing lookups: https://www.excelforum.com/excel-pro...t-process.html
Another one mostly using helper cells and improved lookups: https://www.excelforum.com/excel-for...ows-excel.html

Those should give you plenty to think about.