I'm getting a "Too many cell formats" error.
 

I have a very large file and need these formats. If I close the file and
reopen I can continue formating for a short while before I get the message
again. Is there anything I can do about this?

I'm getting a "Too many cell formats" error.
 

Do NOT save the file after you get that message, or you will never retrieve
it again. There is nothing you can do but try selecting groups of cells and
changing the format.
http://support.microsoft.com/Default.aspx?kbid=213904
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Victoria_in_NY" wrote in message
...
I have a very large file and need these formats. If I close the file and
reopen I can continue formating for a short while before I get the message
again. Is there anything I can do about this?

I'm getting a "Too many cell formats" error.
 

One way out is to use the Format Painter Button. Highlight a block of cells,
hit the Format Painter Button, then click on any cell where you want the same
format. After that try make the formatting uniform for the remaining cells.

"Anne Troy" wrote:

Do NOT save the file after you get that message, or you will never retrieve
it again. There is nothing you can do but try selecting groups of cells and
changing the format.
http://support.microsoft.com/Default.aspx?kbid=213904
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Victoria_in_NY" wrote in message
...
I have a very large file and need these formats. If I close the file and
reopen I can continue formating for a short while before I get the message
again. Is there anything I can do about this?