seven, documents from the abnormal (or other unforeseen reasons) workbook created by the structure of working table of the damage



Sometimes, due to some unforeseen reasons (eg power failure), Excel was forced to withdraw from the abnormal. Although there is no special tools can detect this situation workbook may cause internal damage, but there is reason to believe the number of implications.

If your file does not exist in a number of issues mentioned earlier, at the same time you are convinced that the document is not the normal size, you can try the following method

Create a new workbook, the existing document, one by one cut of the worksheet to a new workbook. Please note here is the "shear" method, instead of "move or copy sheet", not "copy." Yes, the work is to select the contents of the table, and then "cut", move the cursor to the target worksheet, and then "Paste." So the only place that is less than the target worksheet format of rows and columns may have to adjust slightly.