One is that the amount of data itself is large; Second, improper operation causes a large number of blank cells in the table to occupy memory.

How to deal with oversize Excel files;

1. In the first case, you can delete unnecessary content and lose weight.

2. In the second case, you can only create a new excel workbook or worksheet, and copy and paste the negligence in the existing excel table. However, it must be noted that the content to be copied must be selected during the copying process, and the whole table must not be copied and pasted.