Excel文件太大的九大启事剖析及处理办法(国外英文资料).docVIP

Excel文件太大的九大原因分析及解决办法(国外英文资料) Excel file is too big for nine cause analysis and solution Abstract: this article introduces 9 reasons why excel files are too big, and gives specific solutions for specific reasons to solve the problem of excel files. Often a friend asks, Excel file is too big, how to do? The first thing you need to do is find out why there is a solution. This article presents several reasons for the Excel file to give some help to friends who are looking for ways to narrow the size of the Excel file. A lot of friends use Excel2010, lets take a look at how Excel file size is the smallest file in Excel2010. In the same file save format, the generated files are from large to small in the order XLS XLSX. Also, if an excel file is too large for unknown reasons, it can be found in the following areas. Excel files are one of the big reasons: A large number of small picture objects in the worksheet increase the file size. For example, copy the content from the web page directly to the Excel file instead of using the optional paste. Accidentally click on the drawing toolbar line or other graphics object, imperceptibly in a file by inserting small linear or other graphics, due to the very small, almost impossible to see, and through cell replication produced a large number of small graphics object. In the worksheet, other drawing objects are inserted in the worksheet, which is set to a value of 0 or small, and a large number of objects are generated by replication. The excel file that this problem causes is too big, the solution: Press the F5 key, locate the condition, select object, determine to see if there are many small objects selected. But if the column or row is hidden, the object is still not visible. You can then count the objects using VBA to see how many objects are in the worksheet, matching the number of objects you need in your worksheet. Method: press ALT + F11, open the VBE window, click insert - module, copy the following code, and run the F5