Too many different cell formats

[nathan663]

I have received the above message on a workbook, and i am un willing to touch the Spreadsheet to much in case this happens again when i try to open the doc. (this is an important spreadsheet)

It is more than possible that i have 4000 different formats, however i am looking for a way to find out how many exactly i have used... is this posisble?

Also what is the best way to fix this? or lower the number used? i have read somewhere that even if you get rid of formats already used so they are no longer in use, the format is still stored by excel, so it does not actually lower the number of formats you have used... is this correct???

 

[Andrew Poulsom]

There is a macro to list the formats (with an option to delete those not used) here:

http://www.excelforum.com/excel-general/395563-too-many-different-cell-formats.html

 

[RoryA]

Have you started by following the steps outlined in the MSKB article here?

 

[nathan663]

There is a macro to list the formats (with an option to delete those not used) here:

http://www.excelforum.com/excel-general/395563-too-many-different-cell-formats.html

This macro shows what formats are being used or not used, is there a way of getting a number (probably be around 4000) of how many cells have different formats. Including Colours Italics Bold borders etc. Not just on the format of the text

 

[nathan663]

Have you started by following the steps outlined in the MSKB article here?

Yes i have seen this, it doesnt help me an awful lot, my workbook has over 20 tabs, and it is difficult to see where cell have duplicate formats throughout. It would be good to see a number of how many cell formats i have, and when i change something i can run the macro again to see if the number decreases or not