I have an Excel file that has a happy number of sheets with various formulas, ranging from simple sums to far more complex array formulas.
I have always had the sheet set to automatic calculation, but recently due to the size of the file, around 60mb, I changed to manual calculation. When I hit F9 to run the calculation, the status bar changes to
Calculating: (4 Processor(s)): 0% and then sits there.
No matter how long I leave the calculation running, the longest time being overnight, the calculation never rises above 0%. Hitting escape will stop the calculation without issues, indicating Excel itself has not crashed.
I am able to stop the calculation at any point, save and close, and reopen the file without any issues.
I have deleted the most recent array formulas added to eradicate any errors this might have caused.
Has anyone any tips for what else I could check to see what is causing this issue?