Current location - Health Preservation Learning Network - Slimming men and women - Urgent! ! EXCEL cannot be saved because the data is too large, please ask an expert to solve it! ! ! High reward
Urgent! ! EXCEL cannot be saved because the data is too large, please ask an expert to solve it! ! ! High reward
A lot of VLOOKUP is used, which will make the file very large.

"Slimming" method, for cells that find data after using VLOOUP, convert those cells containing VLOOUP formula into numerical values, as follows:

Select the range where you want to convert the formula into a numeric value, copy and paste it as a numeric value selectively.