• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Too Many Different Cell Formates!!!!

B

Baligar

New Member
Hi


I am worked very hard for 2 days in Ms-excel 2003 file size went to 10mb with 30 sheets

after i saved it was fine.


Later while opening a file i got an error of "Too Many different cell formates" and file opened but all the format wht i have done is gone.


Could you plz advice me how to get reslove this...
 
Up until Excel 2007 you had a limit of 4000 cell formats which sounds like alot but that includes every combination of font, lines, colors etc applied to your cells


To fix try:


Apply a standard font to all sheets

Remove all cell fill colors

Remove all cell line styles


Save after each step and reload the file


Also try to re-open the file with the Open and Repair option. This is found using the open dialog, find your file and then use the small drop down on the side of the Open button
 
You must log in or register to reply here.
Back
Top