Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Style problem - unable to delete it

  1. #11
    New Member
    Join Date
    May 2011
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Style problem - unable to delete it

    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
    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.

  2. #12
    New Member
    Join Date
    May 2011
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Style problem - unable to delete it

    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.

  3. #13
    New Member
    Join Date
    Oct 2011
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Style problem - unable to delete it

    Went through multiple forums, tried multiple macros (even from MS Website), and this is the only thing that worked. Thank you for posting.

  4. #14
    New Member
    Join Date
    Mar 2012
    Location
    DFW
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Style problem - unable to delete it

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

  5. #15
    New Member
    Join Date
    Mar 2010
    Location
    California
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Style problem - unable to delete it

    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!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •