Hi all,

I am observing a strange thing with my excel.

I have a reasonably heavy workbook with formulas, where previous versions were taking 3-4 mins to calculate it.

My latest version is slightly more light, but still I am expecting it to take around the same amount of time to calculate.

Problem is, when I recalculate the progress, the progress indicator in the bottom right corner (%) seems to get stuck at certain values (around 70%) (which normally I would say is OK, given the number of calculations), however excel does not go into 'not responding' mode, instead, when the indicator gets stuck, if you select a cell, excel goes back to normal as if it has finished the calculations.

Hence to questions I have are:

1) Why does it do that, and why if I leave my PC for another 10-15mins, the progress will still show 70%. Why excel does not update the progress bar if it has finished calculating?

2) could it be that excel does not finish calculating and either interrupts calculating process itself or I interrupt it when select a cell when indication value seem to stuck.

If you have any ideas, thoughts, I would very much appreciate you sharing those!

Many thanks!

Excel version 2013