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. Read More