Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error: "too many different cell formats"
I am working with a large model (25MBs) and when I try to make formatting
changes I have started to get the error message: Error: "too many different cell formats" What is causing this? Is there a quick fix? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error: "too many different cell formats"
The Microsoft support site discusses this error he
http://support.microsoft.com/default...b;en-us;213904 I encountered this error on a large spreadsheet that I inherited from another user, who had a number of "back office" or "overhead" tabs hidden in the sheet. Even though these sheets were for VLOOKUP purposes and the user never saw them, the sprdsht author formatted these tabs very heavily. I resolved the error in this sprdsht by inserting a new tab, copying one of the cells, highlighting all the cells in an "overhead" tab, and selecting Paste Special Format. This set all the back office tabs to a neutral format, and brought the number of individual format ranges to below the threshhold described in the Microsoft site. This trick might work for you if you also have big ranges of heavily formatted cells that no one looks at. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error: "too many different cell formats"
Dave O: Is this similar to the error message I rec'd..."Excel could not save
all data and formatting you recently added to [Filename]"? "Dave O" wrote: The Microsoft support site discusses this error he http://support.microsoft.com/default...b;en-us;213904 I encountered this error on a large spreadsheet that I inherited from another user, who had a number of "back office" or "overhead" tabs hidden in the sheet. Even though these sheets were for VLOOKUP purposes and the user never saw them, the sprdsht author formatted these tabs very heavily. I resolved the error in this sprdsht by inserting a new tab, copying one of the cells, highlighting all the cells in an "overhead" tab, and selecting Paste Special Format. This set all the back office tabs to a neutral format, and brought the number of individual format ranges to below the threshhold described in the Microsoft site. This trick might work for you if you also have big ranges of heavily formatted cells that no one looks at. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error: "too many different cell formats"
Hi, Guatama100-
Your error is different from the "too many formats" error. I searched the Microsoft Support site and found this, which may apply to your problem. If you click this link, scroll down to find your error message and its cause. http://support.microsoft.com/?kbid=211439 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop the "Too many different cell formats" ? | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |