View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chen Chen is offline
external usenet poster
 
Posts: 1
Default extra excel style

hi,

I have a workbook using a few styles. But a lot of extra unused styles get
into the workbook. There was 3096 yesterday and causing the "too many
different formats" error. So I wrote a macro to delete all these styles that
are not used, and down to 46 styles, which is acceptable. Today, the user
reported to me, again, we have 3085 styles in the workbook. It seems excel
will automatically copy styles from other workbook or something. This
workbook is uses two external csv files as input, and another xls file reads
from it. I checked all three but they don't have many styles.

Please help!