Learn IT

Slow Excel files

Question: Why is my Excel file so slow when opening?

Answer: I hear this problem occasionally and the typical problem is that there are many extra columns or rows included in the data range. Sometimes this is caused by typing something (even pressing the spacebar) in a cell far away from the data or from formatting cells outside the data range. The easiest way to tell is by pressing Ctrl End, which will take you to the last cell of the range. If this is the case, you can try several things

  1. Delete the extra rows and columns outside the range of data
  2. Clear any formatting outside the range of data
  3. Copy the range of data for each worksheet to a new file

Save the file with a different name (File > Save as) and close the file before reopening. You will see the size of the file has reduced considerably and will be much faster in opening.

Leave a Reply