Results 1 to 9 of 9

Not response for 2 minutes when inserting Row, then row Inserted I tried everything i can

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    83

    Not response for 2 minutes when inserting Row, then row Inserted I tried everything i can

    Hi Friends.

    as i posted in the tread.
    On Row 37 I have less than 340 cells with formulas,
    Then via macro/vba I insert a new Row on row 37 and Drag formulas from Row 38 to new (inserted) row 37

    The problem is that its taken almost 2.2 minutes with error message (Not Responding) top left side of the screen when inserting such row. Then when (Not Responding goes Off) the Row is inserted

    I tried the following steps that i know and some others ideas that found on google.
    1-. Disable add in that might interfere with excel (i disabled all of then)
    2-. Find circular reference errors (with Add in, that if request i post the code )
    3-. Find any Formatting that is supposed to be Numbers (not text) and any number supposed to be Text
    4-. Clean Excess of conditional formatting with Microsoft Add in XLSClean.exe)
    5-. Deleted any unused range that previously had data and may Excel is analyzing (Ctrl+End to find the range)
    6-. Repair excel via Uninstal program (control panel)
    7-. Uninstall excel / Installed back
    with in my new workbook i Added a new sheet (add some data) and insert new row manually and the problem happen again.

    If close excel and Run it again
    Open new workbook and on any new sheet i add simple data (1,2,3,4, etc..) and on top of it i add (manually) a new sheet row it does Fast ! (3 seconds !)

    Then please does a guru friend, expert or anyone know a trick that i maybe can help me?
    Sorry but i'm completely Lost.

    May be my Workbook is "corrupted?" BTW: How to fix a Excel XLSB corrupted file?

    if nothing else to do, it might be a possibility..

    NOTE: I can't upload because is 5 mb at this moment, still big for the forum
    (with the XLSClean.exe the file size reduced from 10mb to 5 mb)

    I Appreciated a lot

    I'm tire, sleep for few hours i'll check the forum (may i'm lucky)


    Thanks!!
    Last edited by AndyJr; 12-27-2017 at 01:48 AM. Reason: add the word manually

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inserting Rows and Protected Formulas to Appear on Inserted Row
    By MatthewIJClark in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2017, 10:05 AM
  2. Inserting Rows and Protected Formulas to Appear on Inserted Row
    By MatthewIJClark in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2017, 06:26 AM
  3. Allocating data from a multiple response field to individual response filelds
    By Riddles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2016, 02:15 AM
  4. Macro For Inserting Rows, After Every Nth Row and adding text to the inserted row
    By xxBEANCOUNTERxx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2014, 07:47 PM
  5. Copying and Inserting Range of Rows After Last One Inserted
    By swoosiebur in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-07-2013, 01:54 PM
  6. Inserting a date modified,or date inserted row
    By komet12 in forum Excel General
    Replies: 0
    Last Post: 08-25-2011, 07:50 AM
  7. Improve response time for inserting rows in several hundred sections
    By LAF in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 03:58 PM

Tags for this Thread

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