Office 2007 Styles create issue with "Too many different cell form

[RyanAtWork]

I'm not sure if anyone has come across this issue. I have a file that is used
by both 2007 and 2003 users. Everything was working fine until one day the
2003 users were getting "Too many different cell formats."

The issue was that there were now 3000+ styles on the spreadsheet. There
were now custom styles created for each of the new cell styles in 2007 like
the accents. It looks like everytime this was saved in compatibility mode,
this was turned into a custom style. Eventually there were Accent1, Accent 1
1, Accent 1 2, etc.

This looks like it will continue to be an issue in all sheets unless these
are removed in the first place.

Is there any way to completely disable the new styles from loading in any
worksheet while leaving specific ones like Normal and Comma?

 

[Jim Cone]

Thousands of unneeded/unused styles seems to be a feature of XL2007.
You should be able to automatically delete those unused styles with my free Formats & Styles Excel add-in.
Download from... http://excelusergroup.org/media/
If you give it a try, please post back with your results.
--
Jim Cone
Portland, Oregon USA



"RyanAtWork" <[email protected]>
wrote in message I'm not sure if anyone has come across this issue. I have a file that is used
by both 2007 and 2003 users. Everything was working fine until one day the
2003 users were getting "Too many different cell formats."

The issue was that there were now 3000+ styles on the spreadsheet. There
were now custom styles created for each of the new cell styles in 2007 like
the accents. It looks like everytime this was saved in compatibility mode,
this was turned into a custom style. Eventually there were Accent1, Accent 1
1, Accent 1 2, etc.

This looks like it will continue to be an issue in all sheets unless these
are removed in the first place.

Is there any way to completely disable the new styles from loading in any
worksheet while leaving specific ones like Normal and Comma?