Excel doesn't show cells when busy

[milfor]

This problem isn't related to BA but only to Excel itself.

Each evening I let an Excel-VBA-program analyse the data of the day which
can take quite long. Therefore I have programmed it to show the progress
in a cell. As long as I don't switch to other windows (browser, BA, ...) this
works perfectly but when I display other applications and want to return to
Excel I get only a blank page and the cells are not shown anymore until the
analysis is finally completed. Is there a way to overcome this?

[osknows]

Do a search for 'Loops' & 'DoEvents'

[milfor]

Thanks for the magic word 'DoEvents'.

Excel is like a fairy: It does anything you want if you know the 'magic word'.
But if you don't you're stuck without a search word.