Forum Discussion
Excel calculation slow after version 2308 update
Hello,
We have a large excel model which has property "ForceFullCalculation" switched on due to issues with usability and excel crashing. If Excel is updated to any version past 2307 the calculation time significantly increases (by about 70%) which is an issue when calculating iteratively for instance if we are using Solver. I know that the best solution would be to redesign the Workbook so that we don't have to have "ForceFullCalculation" switched on however we have deliverables that need to be met.
We have rolled back Excel version to 2307 thinking there would be a fix in a more recent version however this has not happened and we don't want to be stuck on version 2307 forever.
Any advice on the cause/solutions to this problem would be greatly appreciated.
- You might want to check for any specific performance improvements or known issues in the release notes for versions past 2307. Meanwhile, optimizing formulas and reducing complexity could help mitigate some of the performance issues.
