Limitations of Microsoft Office Excel

Excel is not omnipotent, in some ways there is always a limit to people feel bad, so we will see the forum of Friends in there to ask some Excel can not do the problem, but you asked me to ask if there is no death to stop the posture. In order to avoid repeated questions from netizens, save everyone's time, I summed up a few, I hope to see a friend inspired. Of course, there must be a place I have not written, it will be supplemented by everyone.

1 The criteria for a custom format cannot exceed 3, but can be added to 6 colors (borders, etc.) through custom cell formatting http://www.excelhelp.net/cgi-bin/forum/topic.cgi?forum=4&topic =1572&show=100. Other restrictions are: Cannot enter the constant array, cannot copy paste, cannot change the conditional order

2 There is no way to add autoformat.

3 functions cannot be nested more than 7 layers (but you can use the "define name" method to remove the restriction of nested functions (http://club.excelhome.net/dispbbs.asp?). boardid=1&id=41113), the number of parameters of a function of up to 30 (also have a breakthrough method http://club.excelhome.net/dispbbs.asp?) boardid=3&id=37274)

4 The length of the name cannot exceed 255 characters, and the character limit of the formula in the cell is 1024 characters.

5 EXCEL is automatically populated, and characters with more than 11 digits cannot be automatically populated.

6 There is no way to insert a GIF animated picture. (But in program development, can you http://club.excelhome.net/dispbbs.asp by referencing the control?) Boardid=2replyid=33300&id=6531&skin=0 or API clock to implement http://club.excelhome.net/dispbbs.asp? boardid=2&id=15676)

7 A reference to a workbook can only be an absolute reference and cannot be a relative reference.

8 The reference in effectivity must be a reference to a range of cells and cannot use an array formula.

The text in 9 cells can set the color font separately, but there is no way to set the spacing between two lines of text in the same cell Gegne.

10 in a shared workbook, cells cannot be moved, cannot be inserted, cannot be sorted, and none of the data involved can be moved.

11 scenarios in Scenario manager have up to 32 variable cells, and formulas entered in changing cells are converted to numeric storage.

12 shortcut to format brush and merged cells not found

The maximum size of the 13 font is 409 lbs, which is the maximum size of the 10cmx10cm word.

14 The number of rows in the AutoFilter list is up to 1000, but does not mean that it cannot be filtered without showing.

15 The Consolidate feature can only hold one set of merged data at a time.

Limitations in Version differences: (Since my office is only 2000 and 2003, other versions of Excel want to provide testing)

1 cannot rotate the inserted picture in the 2000 version, 2003 in the tool bar this rotation tool

2 in the 2000 version of the "China * Olympics" in the middle with the * number of the field filter will be a problem. This problem is not available in version 2003.

3 XP version below in footer and header there is no way to insert a picture.

More than 4 2000 versions can be centered across rows in a cell format to achieve the previous "merged cells" effect.