excel 2000 - too many different cell formats??? 1

[creeker69]

I use Excel 2000 on windows2000. I created a sheet (actually not really that large, A1:AC82) and during my creating it, I colored several cells to make my data easier to read and assemble.

Now that I am done, I wanted to get rid of the cell colors by clicking on "no fill", and an error box pops up and says "Too many different cell formats.".... I can only click OK. Any ideas why and how I can correct this? Some cells will allow me to "no fill" individually, but some, even empty ones, won't.

Thanks in advance!
creeker69

 

[Dreamboat]

Hi, creeker.

Have you read the Technet article on it yet?

http://support.microsoft.com/default.aspx?scid=kb;[LN];213904

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[creeker69]

Anne,

Thank you for the link. I deleted some sheets that the data came from and I eliminated the error. Amazing to me that these sheets could contain 4,000 formats!

Thanks again!,
creeker69

 

[Dreamboat]

Yep. Amazing...until you think about it. Suppose you have a cell with arial, number format, and a border on the right. That's one format. Another has arial, number format, and a border on the left. That's another format...

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books