I've been using Excel from Office 365 for the last 2 years on Windows 10 and get crashes almost daily. I need to have several workbooks open at any one time but don't see why this should be an issue as it wasn't when I was previously using an older version of Excel. I've just come across a link on the official MS Office website here and was shocked to see the following;
The following things can cause performance or crashing issues:
Formulas referencing entire columns.
I'm referencing entire columns all the time using several functions such as
average, etc. eg:
=average(A:A) and surely I can't be the only one.
Is this likely to be the cause and does anyone know of a workaround?