Current location - Health Preservation Learning Network - Slimming men and women - Excel files will become very large after many edits. How to slim down and open them faster?
Excel files will become very large after many edits. How to slim down and open them faster?
Just select "Edit Link" and delete it. This window will not pop up.

If the file size is not the cause of too much data, check whether there are any formats in the non-data area of each worksheet. For example, set a border or shading for all rows, or set a border or shading for an entire column. What I know about the soaring amount of Excel is basically the same as this, with unnecessary formatting. Because in order to save trouble, people who do Excel are likely to directly select the whole row or column and then apply the format.

The solution is to select all culling formats, and then format only the data areas that need to be formatted.