One idea -

Rob Bovey's excellent Utilities add-in will list all the formats in use in
your workbook, allowing you to manually delete what isn't being used.

http://www.appspro.com/Utilities/ExcelUtilities.htm

You can also see the source code for the add-in, and could probably modify
it to delete the unused formats



"Craig" wrote:

I am running into the error message:

Too many different cell formats

Is there a solution to lowering the number of formats I
am using? Just trying to change them to make some
consistent gives me the same error message.

I tried running the search on the forums on my topic but
they have been disabled for a Microsoft upgrade.

Thanks!