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
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?