Too many formats - how solve this problem,

[Guest]

There are too mary format in the excel workbook I'm working on, and now looks
like the format limitation has been reached. Now does not allow any more
formats in the excel workbook which I'am working on.

 

[Nick Hodge]

Manoj

A Format is *any* combination of font colour/size/type, back ground colour,
etc so it is easy to hit this limit (In versions before 2007, as the limit
is vastly increased in this version)

Your best bet is to set up some styles (Format>styles) and apply these where
you can as this cuts down the number dramatically.

Simply, there is no way over it apart from to cut them down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk