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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DWBSC1 - 17 Dec 2004 01:39 GMT

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

Reply to this Message

Kevin H. Stecyk - 17 Dec 2004 03:13 GMT

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

Reply to this Message

DWBSC1 - 17 Dec 2004 03:29 GMT

> DWBSC1...
> > How do I clean up an Excel file if I get an error stating that I have too
[quoted text clipped - 8 lines]
>
> Thanks Kevin. I was really hoping that there was a free utility or macro of some sort that would help facilitate the process.

Reply to this Message

Kevin H. Stecyk - 17 Dec 2004 07:11 GMT

DWBSC1 wrote...

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

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

Reply to this Message