Assuming the MS Cleaner works (I haven't tried it), this seems to be a
hardcoded limit, in which case there's no way around it. You'll have to remove
some formats.

On Sun, 13 Mar 2005 16:18:49 -0800, jimhallen
wrote:

Dana,

I tried Microsoft's "Cleaner" but it didn't help. I have the same problem,
my spreadsheet has
grown over time and I'm bumping up against the 4000 cell format limit. Have
you found
any ways around it?

Jim Allen


"Dana DeLouis" wrote:

Has anyone used the "Microsoft Excel Excess Formatting Cleaner Add-in" ??


http://www.microsoft.com/downloads/d...displaylang=en

If you use it, please let us know how it worked. :)

HTH
Dana DeLouis



"Frank Kabel" wrote in message
...
Hi
for dealing with too many cell formats have a look at the following KB
article
http://support.microsoft.com/default...b;en-us;213904

--
Regards
Frank Kabel
Frankfurt, Germany

"wsdanalyst" schrieb im
Newsbeitrag ...
I have a set of spreadsheets that I am unable to change the format of
any
cells. When I try to change the background color, font or font size,
an
error message pops up saying there are too many cell formats. I
really want
to avoid having to re-create all of these spreadsheets. Please help.
Thank
you.