+ Reply to Thread
Results 1 to 4 of 4

Worksheet continues to freeze and say NOT RESPONDING

  1. #1
    Forum Contributor
    Join Date
    05-29-2012
    Location
    Walnut, Ca
    MS-Off Ver
    Excel 2010
    Posts
    182

    Worksheet continues to freeze and say NOT RESPONDING

    Could someone please help, my workbook functions normally but one worksheet keeps getting hung up. Anytime I switch cells it says NOT RESPONDING or it just freezes for a few moments. The "AG ORDERS" spreadsheet is the problematic one and it is also the most important spreadsheet.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    Re: Worksheet continues to freeze and say NOT RESPONDING

    Well, clearing the conditional formats from the sheet stopped the lag completely. So that might be one clue as to what's causing the issue.
    The VBA code in the worksheet is also doing an application calculate every time a cell is changed.

  3. #3
    Forum Contributor
    Join Date
    05-29-2012
    Location
    Walnut, Ca
    MS-Off Ver
    Excel 2010
    Posts
    182

    Re: Worksheet continues to freeze and say NOT RESPONDING

    The same VBA code is on the Student worksheet and there doesn't seem to be a lag on the sheet.

  4. #4
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    Re: Worksheet continues to freeze and say NOT RESPONDING

    Sorry, that was more of an aside regarding the VBA. Your issue seems to be related to the Conditional Formats on the sheet I would say.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Not Responding...freeze
    By itselflearn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2015, 10:24 AM
  2. macro w/ Freeze panes keeps shifting where panes freeze on worksheet
    By sschwant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2015, 02:30 AM
  3. [SOLVED] macro error Copy Time format to other Worksheet and continues copy range
    By feroguz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-25-2012, 01:30 PM
  4. Images on Worksheet not responding to events
    By Steveh111 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 08:30 PM
  5. Worksheet Event not responding
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2009, 07:53 AM
  6. Worksheet change event not responding to cell deletion
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-14-2008, 06:30 PM
  7. Worksheet change event not responding to cell deletion
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2008, 03:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1