Yesterday there is a friend of intranet ask to through enamel about message of error " error “Too many different cell formats " what emerge at Microsoft Excel.
Because it is true i do not know and have never experienced of the occurence, I am only can reciprocate will try to look for soybean cake. Mentioned of me use opportunity intentionally searching it and find page of Help and Support Microsoft.
Mentioned, message of error like that will emerge when a pregnant workbook more than about 4.000 format combination of cell different. This combination are including format of font, border, patern, number, and alignment of cell protection. If two or more cell use in same format precisely mean to use one format combination. If there is a few difference of format at some cell, each using different combination.
To overcome the problem, solution given by Microsoft is to conduct moderation of format. Some the suggested is to
Using type of font is same in each cell-nya
Using border consistently. If applying right border at one particular cell, hence needn't apply left border at cell on the right
If applying pattern at cell, eliminating pattern-nya by chosening No Color at Patterns tab in box dialogued by Format Cells.
Having taken steps moderation of format, keep, cover and reopen workbook-nya.
No comments:
Post a Comment