software

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: quot;too many different cell formatsquot;

What is causing this? Is there a quick fix?

The Microsoft support site discusses this error he
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 quot;back officequot; or quot;overheadquot; 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 quot;overheadquot; tab, and selecting gt;Paste Special gt;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.Dave O: Is this similar to the error message I rec'd...quot;Excel could not save
all data and formatting you recently added to [Filename]quot;?

quot;Dave Oquot; wrote:

gt; The Microsoft support site discusses this error he
gt; support.microsoft.com/default...b;en-us;213904
gt;
gt; I encountered this error on a large spreadsheet that I inherited from
gt; another user, who had a number of quot;back officequot; or quot;overheadquot; tabs
gt; hidden in the sheet. Even though these sheets were for VLOOKUP
gt; purposes and the user never saw them, the sprdsht author formatted
gt; these tabs very heavily. I resolved the error in this sprdsht by
gt; inserting a new tab, copying one of the cells, highlighting all the
gt; cells in an quot;overheadquot; tab, and selecting gt;Paste Special gt;Format. This
gt; set all the back office tabs to a neutral format, and brought the
gt; number of individual format ranges to below the threshhold described in
gt; the Microsoft site.
gt;
gt; This trick might work for you if you also have big ranges of heavily
gt; formatted cells that no one looks at.
gt;
gt;

Hi, Guatama100-
Your error is different from the quot;too many formatsquot; 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.

support.microsoft.com/?kbid=211439