Has anyone ever received this message? I use a ton of colors and formatting
on a large, 20 tab excel file. This message pops up after I hit a certain
point and I can't format any more or ALL formatting gets blown out. This is
a huge problem. Does anyone know how to fix it so I can format more?

Hi Mark,
What you do is place the exact message that you get between
quotes and do a Google Groups search.

You can search Google Groups on your error message
http://groups.google.com/advanced_gr...Excel*&num=100
Search all words: "Too Many Different Cell Formats"
author: Leo Heuser

A recent thread
"Too many different cell formats" apply on excel 2007
http://groups.google.com/groups?thre...GP03 .phx.gbl

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Mark Hughes" wrote in message ...
Has anyone ever received this message? I use a ton of colors and formatting
on a large, 20 tab excel file. This message pops up after I hit a certain
point and I can't format any more or ALL formatting gets blown out. This is
a huge problem. Does anyone know how to fix it so I can format more?