Style problem - unable to delete it

[klb]

I have a style in a large and complicated workbook (over 20 sheets) that I want to delete. Unfortunately it once was a Normal style in another workbook and I have been unable to delete it. I also have a "regular" Normal style that cannot be deleted.

I am trying to clean up this workbook for distribution to others in our organization. There are sheets within the workbook that will be made a part of other workbooks. Getting rid of this unwanted style is not critical it is just one of those things that bug me. (we have all been there)

Any help would be greatly appreciated.

 

[XLGeek]

More information on the same subject in this tread: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/excel-found-unreadable-content-in-bookname-without/957efce2-fdc8-4d47-94f6-dab6670604b0?page=2<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Open XML file manipulation is the best way to deal with this. VBA or other Excel OM based algorithms can’t delete styles marked as hidden or built-in. OOXML based programmatic solutions (vs. doing it by hand) would eliminate the risk of corrupting the file, but doing the cleanup by hand works to. Excel client save of the file post manual update of styles.xml would take care of removing other content like custom number formats no longer referenced in styles definition nodes. You should see noticeable file size drop after the cleanup and save.<o></o>

 

[scfranklin94]

DrillRaider, thanks for posting this. I had a spreadsheet with 64,841 different styles in it (probably due to multiple repairs over the years). I'm not an XML user, but this worked like a charm.

 

[dl_excel]

Went through multiple forums, tried multiple macros (even from MS Website), and this is the only thing that worked. Thank you for posting. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[dVorderb]

Thanks! This helped me get rid of a couple of dead Styles that could not be found!

 

[Jon Acampora]

Thanks! I was able to delete a few problem styles without having to reset styles that I had already modified and used in the file. Awesome!