WPS form is a commonly used office software. Recently, many users have reported that they have encountered the problem of errors in opening WPS form. Next, I will teach you the solutions to errors in opening WPS form. I hope it will be helpful to you!
1. Click to create a new form;
2. Click the triangle drop-down menu in the upper left corner;
3. Select "tools" - "backup management";
4. Click "other backup" in the editing window on the right, and then find the file in the pop-up window and restore it.
After opening the excel table, delete the useless objects and use the object viewer
Deleting all existing objects often leads to so many transparent text boxes due to wrong operations and repeated copying.
If there is not much data in this table, and there are many objects (tens of thousands) in the worksheet, and the formula is not complex, it is recommended that the landlord select all from the table area (you can select A1 first, then press and hold shift and then select z118), then copy, open a new blank excel table and paste it in.
Yes, the formula will be lost, but since the formula is not too complex, you can fill in the formula again and fill it automatically, which is much faster than deleting the more than 60000 boxes. After this test, the file size will be reduced, and I have not recovered after this test.
Select XLS extension in Explorer - tools - Folder Options - file type, and click Advanced - select“
Open "- click" Edit "- add"% 1 "after / E in the" application for editing "(Note: be sure to add spaces and" "sign) for example:" D: \ program \ Microsoft Office \ office11 \ excel Exe "/ E"% 1 "/ DDE. Note that this order must be correct, and other orders are wrong. Cancel the check before" using DDE "and click OK. Your excel opening speed will be greatly improved without delay.
Similarly, xlsx is an Excel 2007 document format, and the above operation is also followed.