+ Reply to Thread
Results 1 to 5 of 5

Removing Conditional Format Crashes Excel

Hybrid View

  1. 01-23-2015, 06:30 PM #1
    tomnewengland
    tomnewengland is offline
    Registered User
    Join Date
    10-15-2014
    Location
    RI
    MS-Off Ver
    2010
    Posts
    6

    Removing Conditional Format Crashes Excel

    I have a workbook with a ton of conditional formatting. It is slowing it down. There are mutiple versions of this file used by multiple people. The versions created in Excel 2010 that have been opened and manipulated by others in Excel 2007 are now extremely slow. I am now trying to just remove all formatting in the files but as soon as I choose remove all from entire sheet, excel crashes and goes to not responding...I have given it 20 minutes and nothing. By the way I have tried to remove from a single cell and got the same result.

    Is there a back door to clearing this out of the sheet?

    Please let me know
    Thank you
    Reply With QuoteRegister To Reply
  2. 01-23-2015, 06:49 PM #2
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Removing Conditional Format Crashes Excel

    You can try removing it with VBA.

    Sheets("MySheet").Cells.FormatConditions.Delete
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
    Reply With QuoteRegister To Reply
  3. 01-23-2015, 06:49 PM #3
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Removing Conditional Format Crashes Excel

    You can open the file using a PKzip utility such as PKUnzip, PKZip, etc. First, make a backup.

    You'll have to change the file type display to ALL for it to show up when you're browsing to the filetype.

    When you the file is displayed, you'll see all the extra datatypes that are attached to the core file, such as formatting, formulas, styles, borders, connections and more.

    Remove the format/style and see is that works.


    I've used this method in the past to salvage data from workbooks suffering from bloat, such as 10 MB files with 50 GB of formatting and styles compounded on it. It's only really useful when the workbook won't even open.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!
    Reply With QuoteRegister To Reply
  4. 01-23-2015, 06:52 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Removing Conditional Format Crashes Excel

    Another suggestion...

    Not sure about 2010, but 2007 CF has an annoying habit of duplicating CF rules when a CF cell gets copied - and then re-doubling and re-re-doubling. 1 way to get rid of those, is to go in and delete all teh duplicate rules
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  5. 01-25-2015, 07:12 AM #5
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Removing Conditional Format Crashes Excel

    Hi,

    Does putting the workbook into Manual calculation mode first help?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sending excel format but removing all links.
    By aaslezak in forum Excel General
    Replies: 6
    Last Post: 10-15-2012, 03:01 AM
  2. Excel 2010 crashes when clicking chart tools format tab
    By tking42 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-19-2012, 01:01 PM
  3. Excel crashes every time I try to format
    By gonger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2008, 07:57 PM
  4. Excel crashes as soon as I try to format cells?
    By Mike in forum Excel General
    Replies: 0
    Last Post: 05-19-2006, 01:25 PM
  5. Save in Multiple format crashes Excel 2000 SP3!
    By Gadgetier in forum Excel General
    Replies: 1
    Last Post: 11-17-2005, 08:40 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1