How do I clean up an Excel file if I get an error stating that I .

[Guest]

How do I clean up an Excel file if I get an error stating that I have too
many cell formats?

 

[Kevin H. Stecyk]

DWBSC1...

How do I clean up an Excel file if I get an error stating that I have too
many cell formats?

I have seen reference to this before. You just have to reduce the number
of cell formats. Less is better. I have seen reference that the maximum
number of cell format is 4000, but you should be well short of that.

Regards,
Kevin

 

[Guest]

DWBSC1...

I have seen reference to this before. You just have to reduce the number
of cell formats. Less is better. I have seen reference that the maximum
number of cell format is 4000, but you should be well short of that.

Regards,
Kevin


Thanks Kevin. I was really hoping that there was a free utility or macro of some sort that would help facilitate the process.

 

[Kevin H. Stecyk]

DWBSC1 wrote...

I am not sure what you are looking for. Do you simply want a macro to blast
all your formats? That can be done easily enough, though I am not sure that
is the best way to go.

Otherwise it is hard to design a macro without knowing your spreadsheet.

If you spreadsheet is well designed, there ought to be a lot of symmetry, so
once you format some cells, the rest go fairly quickly.

Regards,
Kevin