What is the reason why excel runs slowly?

The reasons are: 1. There may be many small objects in the file that need to be deleted; 2. The slider is very small, and you can reach a very large line number by dragging it downward; 3. The file contains a lot of complex formula; 4. Large pictures are used as the work background; 5. Shared workbooks cause an inflated volume.

The reason why excel runs slowly is:

1. There may be many small details in the file that cannot be seen by the naked eye. Objects can be located using F5, and then deleted.

2. The slider is very small. Just drag it downwards and you will reach a very large line number. However, the actual area used is very small, even less than 200 lines. It is very likely that a large area will be used. Cell format or conditional formatting is set. Click the next row of the actual used area, press "Ctrl Shift Down Arrow", select all redundant rows, edit-clear-all.

3. Same as 2, delete the possible data validity settings.

4. The file contains a large number of complex formulas. Optimize the formulas. For example, use names instead of cell references in the formulas.

5. Using a large picture as the work background

6. Sharing the workbook causes an inflated volume. Please cancel first, then save, and then enable sharing.

7. The last resort: File - Save as web page, save the entire workbook, uncheck Add Interaction, name the file as you like, and close Excel. Start Excel, open the HTM file you just saved, check whether the data and format are normal, file - save as, select Microsoft Office Excel workbook (*.xls) as type, enter the file name and confirm

Recommended tutorial: "excel tutorial"

The above is the detailed content of What is the reason why excel runs slowly?. For more information, please follow other related articles on the PHP Chinese website!