+ Reply to Thread
Results 1 to 4 of 4

Inserting rows crashing excel

  1. #1
    Registered User
    Join Date
    01-17-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    67

    Inserting rows crashing excel

    Hi folks,

    I created three spreadsheets with pivot tables and macro's and tables in excel 2007. Then my computer crashed, so I has to re-install Windows and Excel.

    The problem now is that if I insert a row anywhere in any of the spreadsheets, Excel either takes a really, really long time (three or four minutes) to insert the row, or it just crashes and I have to restart.

    I can't understand what's causing the crash, I tried disabling macros, deleting certain tables, but it doesn't help. Is this a recognized problem? I even tried re-installing Excel - no good.

    I have to insert rows from one spreadsheet to another so this is becoming a real issue, a five minute job is taking an hour when I include time to recover from crashes etc.

    Thanks for your help,
    AR

  2. #2
    Registered User
    Join Date
    01-17-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: Inserting rows crashing excel

    OK if anyone has a similar problem it comes down to conditional formatting.

    I had some 700 cells with overlapping conditional formatting, so once I cleared that the sheets returned to operating normally.

  3. #3
    Registered User
    Join Date
    03-12-2012
    Location
    asldfh
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Inserting rows crashing excel

    Its been ages since this post but just helped me a lot! I was having the same problem, excel crash when adding a row to a table that had conditional formatting. I reapplied conditional formatting to the whole 2 columns instead of how I had it before where it only applied to rows 5 to 200.

    Thanks a lot !

  4. #4
    Registered User
    Join Date
    09-14-2017
    Location
    GURGAON
    MS-Off Ver
    2013
    Posts
    1

    Re: Inserting rows crashing excel

    Hi

    Just select all. Go to Home > Conditional formatting > Clear Rules > Clear Rules from Entire Sheet.

    This will do the trick.

    Regards

    Srini

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1