Regular crash in Excel – Possible cause that refers to the entire column

I have been using Office 365 Excel for the last 2 years in Windows 10 and I fall almost daily. I need to have several books open at the same time, but I do not understand why this should be a problem, since it was not when I was using an earlier version of Excel.
I just found a link on the official MS Office website here and I was surprised to see the following;

The following things can cause performance problems or failures:

Formulas that refer to whole columns.

I'm referencing whole columns all the time using various functions like sumifs, average, etc. for example: = average (A: A) And surely I can not be the only one.
Is this likely to be the cause? Does anyone know of a solution?