I have an financial model in excel where calculation is set to automatic that will not update - even when pressing F9. The model is iterative and interation is on. The only way to get cells to update is to F2 into each cell and then just hit enter without making any changes and it will update properly.
Any global solution for this - we have had this problem on several files over the last several weeks.
Any global solution for this - we have had this problem on several files over the last several weeks.