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) copy content from the web page directly to the worksheet, instead of using the optional 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 values, has a large object by copying (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, thus make insert objects cant see The object in the worksheet sets the line and the fill color of the invisible attribute (Visible = false) or the object, which is the same as the background color, so that the object cannot be seen Judgment method: (1) edit - positioning (shortcut: F5 or Ctrl - G), select object location condition, 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 Sub countshapes () Dim n n = ActiveSheet. Shapes. Count MsgBox this worksheet Shared n object End