Form writing functions, especially repeated calls, will inevitably lead to more and more redundant garbage in this file, the file is getting bigger and bigger, and the opening is getting slower and slower. I met a 24M single gear, which took 10 minutes to open, but after slimming, it was only 5M, and it opened much faster.

To put it bluntly, it's not that your computer is slow, but that it takes time to write this form into memory.

My solution is for reference only:

1. Create a new blank table file B (tentative)

2. Open the original file A of the form, copy all the contents of a label in the form A, selectively paste (data) into the file B, and then selectively paste (format) into the file B ... (If there are merged cells in the table, you may need to paste them multiple times by region. )

3. Paste the functions in Table A into Table B in the form of "text". Of course, you only need to paste the first row or column, and you can drag and drop the rest (you know this).

4. After all the operations are completed, change the file name of the original file A to "A (backup-1)" and rename the file B to A. ..

5. After all files are "copied", save this file as a "template". Next time you do it, you won't have to go to so much trouble.

Description:

Be sure not to paste the whole page, which will bring redundant junk to the form.

At present, there are 46 functions and more than 500 lines in the function table I use, including filtering, comprehensive judgment, array and other functions. It is possible to use this method. Landlord, try it.