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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I clean up an Excel file if I get an error stating that I have too
many cell formats?
 
DWBSC1...
How do I clean up an Excel file if I get an error stating that I have too
many cell formats?
Click to expand...

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
 
Kevin H. Stecyk said:
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.
Click to expand...
 
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
 
Back
Top