Excel文件太大处理方法(国外英文资料).docVIP

Excel文件太大处理方法(国外英文资料) A lot of people in the process of actual use EXCEL in EXCEL file unexplained, open the calculation are very slow phenomenon, sometimes even cause the file is damaged, cant open the case, the following is my collection of the cause of file inflated and treatment method, made no mention of other conditions and solution, welcome everyone to give added: A large number of small picture objects in the worksheet increase the file size, which is the most common form of the file. Possible reasons: (1) copied from the web page content paste directly to the work table, without the use of selective paste, (2) has no intention of the middle line of the drawing toolbar or other graphics object, imperceptibly in a file by inserting small linear or other graphics, due to the very small, almost to the naked eye cannot see, and through cell replication produced a large number of small drawing object (3) insert the picture in the worksheet other graphics object, operation and its height width is set to zero or very small value, produced by copying a large amount of objects (4) the location of the row or column in the insert a drawing object, attribute of an object is, the size of the location with unit (the default), then hide the row or column, or set the line height or column width to small value, so that the insert object cannot see (5) set the invisible property of objects in the worksheet (Visible = false) or the lines of the object and the fill color are set to the same as the background, the object cannot see Judgment method: (1) the CTRL - G, location, location conditions, select object, will be displayed after a lot of the selected small objects (object of this method in the hidden columns or rows cannot see) (2) use VBA to count objects, and see how many objects in the worksheet, and your job need to match the number of objects in the table The Sub countshapes () Dim n = ActiveSheet. The Count MsgBox has a total of n object, End Sub Solution (1) if t