Excel files can exist on the computer for a long time. They are upgraded from version to version, and frequently travel from one user to another user. If you are unaware of the details and contents of a file, you should review the file to determine if it has any of the below items.
The following items can cause performance or crashing issues:
-
Formulas referencing entire columns.
-
Array formulas referencing an uneven number of elements in the arguments.
-
Hundreds, or perhaps thousands of hidden or 0 height and width objects.
-
Excessive styles caused by frequent copying and pasting between workbook.
-
Excessive, and invalid defined names.
