"M" wrote in message
...
When I try to change cell formats, there's a pop-up coming up; "Too many
different cell formats" . I have tried to clear some not importent sheets
with Edit/clerar/formulas, but it doesn't help.

I really need help....

Clearing formula won't help. You need to delete some custom formats. The
problem is that these accumulate over time, as they remain even if not used.

Take a look he
http://j-walk.com/ss/excel/eee/eee007.txt

In the section "POWER PROGRAMMING TECHNIQUE By Leo Heuser" you will find
code to search for unused custom formats and delete them. It's very
effective.