Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
I keep getting the message "Too many different cell formats" which is
prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
Further to my question.
I am trying to remove some formatting (am avoiding the Edit-Clear-Format command for the moment as this will require me to carry out a major reformatting of over 60 worksheets), but I am not being permitted to undo such formats. I basiccally need to avoid redoing most of my work. -- Paul Gauci "Paul Gauci" wrote: I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
Paul
The limit is easy to reach in versions pre 2007. Any difference is counted as different, size, colour, border, bold, etc. You will need to clear some to allow you to get by the error, but then set up some styles under FormatStyles... This way you can be sure you are formatting 10 different styles all the same rather than the random way most formatting is organised. Still may mean re-doing quite a bit of work -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Paul Gauci" wrote in message ... I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
Maybe...
XL: Error Message: Too Many Different Cell Formats http://support.microsoft.com/default.aspx?scid=213904 A few people have said that OpenOffice.Org has been able to open the file. Then they clean it up and save it there. Then excel can open that cleaned up version. http://www.openoffice.org, a 60-104 meg download or a CD Paul Gauci wrote: Further to my question. I am trying to remove some formatting (am avoiding the Edit-Clear-Format command for the moment as this will require me to carry out a major reformatting of over 60 worksheets), but I am not being permitted to undo such formats. I basiccally need to avoid redoing most of my work. -- Paul Gauci "Paul Gauci" wrote: I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
Thanks Dave
Actually some time ago I experienced a corruption of a Word file which contained a large multi-page table and I managed to solve the problem by following the Open Office procedure. I tried it out as a last resort after the save-to-web page approach failed. I shall try this procedure out with my excel file and post the result. Paul -- Paul Gauci "Dave Peterson" wrote: Maybe... XL: Error Message: Too Many Different Cell Formats http://support.microsoft.com/default.aspx?scid=213904 A few people have said that OpenOffice.Org has been able to open the file. Then they clean it up and save it there. Then excel can open that cleaned up version. http://www.openoffice.org, a 60-104 meg download or a CD Paul Gauci wrote: Further to my question. I am trying to remove some formatting (am avoiding the Edit-Clear-Format command for the moment as this will require me to carry out a major reformatting of over 60 worksheets), but I am not being permitted to undo such formats. I basiccally need to avoid redoing most of my work. -- Paul Gauci "Paul Gauci" wrote: I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
Thanks Nick
The problem is that Excel is not permitting the editing of existing formats. Paul -- Paul Gauci "Nick Hodge" wrote: Paul The limit is easy to reach in versions pre 2007. Any difference is counted as different, size, colour, border, bold, etc. You will need to clear some to allow you to get by the error, but then set up some styles under FormatStyles... This way you can be sure you are formatting 10 different styles all the same rather than the random way most formatting is organised. Still may mean re-doing quite a bit of work -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Paul Gauci" wrote in message ... I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
Dave
I have tried the Open Office procedure and it has worked. Now I am in a position to reformat the file. Until I tried this procedure I was finding it very difficult [well, actually impossible] to reformat the file and was about to apply the Edit-Clear-Format command to all the sheets. Paul Pau -- Paul Gauci "Dave Peterson" wrote: Maybe... XL: Error Message: Too Many Different Cell Formats http://support.microsoft.com/default.aspx?scid=213904 A few people have said that OpenOffice.Org has been able to open the file. Then they clean it up and save it there. Then excel can open that cleaned up version. http://www.openoffice.org, a 60-104 meg download or a CD Paul Gauci wrote: Further to my question. I am trying to remove some formatting (am avoiding the Edit-Clear-Format command for the moment as this will require me to carry out a major reformatting of over 60 worksheets), but I am not being permitted to undo such formats. I basiccally need to avoid redoing most of my work. -- Paul Gauci "Paul Gauci" wrote: I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
Thanks for posting back your results.
Paul Gauci wrote: Dave I have tried the Open Office procedure and it has worked. Now I am in a position to reformat the file. Until I tried this procedure I was finding it very difficult [well, actually impossible] to reformat the file and was about to apply the Edit-Clear-Format command to all the sheets. Paul Pau -- Paul Gauci "Dave Peterson" wrote: Maybe... XL: Error Message: Too Many Different Cell Formats http://support.microsoft.com/default.aspx?scid=213904 A few people have said that OpenOffice.Org has been able to open the file. Then they clean it up and save it there. Then excel can open that cleaned up version. http://www.openoffice.org, a 60-104 meg download or a CD Paul Gauci wrote: Further to my question. I am trying to remove some formatting (am avoiding the Edit-Clear-Format command for the moment as this will require me to carry out a major reformatting of over 60 worksheets), but I am not being permitted to undo such formats. I basiccally need to avoid redoing most of my work. -- Paul Gauci "Paul Gauci" wrote: I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
FYI, http://office.microsoft.com/en-us/ma...938821033.aspx Dave Peterson a écrit : Thanks for posting back your results. Paul Gauci wrote: Dave I have tried the Open Office procedure and it has worked. Now I am in a position to reformat the file. Until I tried this procedure I was finding it very difficult [well, actually impossible] to reformat the file and was about to apply the Edit-Clear-Format command to all the sheets. Paul Pau -- Paul Gauci "Dave Peterson" wrote: Maybe... XL: Error Message: Too Many Different Cell Formats http://support.microsoft.com/default.aspx?scid=213904 A few people have said that OpenOffice.Org has been able to open the file. Then they clean it up and save it there. Then excel can open that cleaned up version. http://www.openoffice.org, a 60-104 meg download or a CD Paul Gauci wrote: Further to my question. I am trying to remove some formatting (am avoiding the Edit-Clear-Format command for the moment as this will require me to carry out a major reformatting of over 60 worksheets), but I am not being permitted to undo such formats. I basiccally need to avoid redoing most of my work. -- Paul Gauci "Paul Gauci" wrote: I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
"Paul Gauci" wrote: I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I deal with a "Too many different cell formats".
Hi Richard,
Did you look at the entire thread you posted in for previous answers, the poster accepted the first solution offered which was by Dave Peterson, which was 18 days before your 'reply' post trying to reactivate it without any input. http://google.com/groups?threadm=45A...zonXSPAM.ne t The other solution that was offered, after the first solution was found to work, was a package to purchase. If you want to read more see http://www.mvps.org/dmcritchie/excel...sp.htm#formats If you do not see an entire thread you might want to check out the posting in Google Groups to read the entire thread. See http://www.mvps.org/dmcritchie/excel/xlnews.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "richard30097" wrote in message ... "Paul Gauci" wrote: I keep getting the message "Too many different cell formats" which is prfeventing me from completing my current assignment. The file that I am working on has grown to about 4MB. Is there a way in which I can go around thgis probelm? -- Paul Gauci |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: "Too many different cell formats" | Excel Discussion (Misc queries) | |||
Error: "too many different cell formats" | Excel Discussion (Misc queries) | |||
How do I stop the "Too many different cell formats" ? | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |