Does anyone know why cells may look empty, without actually having lost their
contents, when scrolling up or down quickly?

They will not refresh correctly until they are moved of and then on the
visible window again, of course after having stopped the fast scrolling.

This happens regardless of xls or xlsm file type.