Excel 2000 Not enough formats

  • Thread starter Thread starter casper
  • Start date Start date
C

casper

I got a big file in excel 2000 but now every time i want to add a cell/cell
format excel is stating: "not enough formats".

is there a way around this?

Or a way to treat this?

looking forward to the awnser!!
 
This is a common problem in large workbooks, especially ones that have
been used internationally

There is some good info here:
http://support.microsoft.com/kb/213904

There is a commercial tool for exactly this here:
http://www.rowingservice.com/quarrell/QAid/

In simple terms you need to reduce the number of format combinations. If
you have lots of charts that would be the best place to start - set all
axis fonts to a fixed size.

After that go through the workbook simplifying formatting eg by only
using a single font, by only using 2 or 3 background colours etc.

If you are copying in from other workbooks do a paste special values or
formulas rather than a normal paste as that often brings a load of
formatting junk in.

Cheers
Simon
Excel development website: www.codematic.net
 
Back
Top