+ Reply to Thread
Results 1 to 2 of 2

Excel freezing when I want edit cell

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Excel freezing when I want edit cell

    Hello

    What the common reasons for excel freezing when I write in the cell?
    its unfreeze when I click close and the save dialog shown, and freeze again when I am trying to edit any cell,

    On the sheet there is one table with 7 columns and 150 rows, one columns has data validating, vba sheet change event not there

  2. #2
    Registered User
    Join Date
    04-09-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Excel freezing when I want edit cell

    If Excel freezes in any file you open, it is likely related to the program itself.

    Start Excel in Safe Mode
    1. Close completely out of Excel.
    2. Hold the Windows Key and press ?R? to bring up the Run dialog box.
    3. Type excel -safe then press ?Enter?.
    4. If Excel opens with the above steps, it is likely that a plugin or other software is installed that is interfering with the software. Proceed with step 4 to try to fix the issue. If you still experience problems with Excel started in Safe Mode, try the next set of instructions.
    5. Select ?File? > ?Options?.
    6. Select ?Add-ins?.
    7. Select ?Excel Add-ins? in the ?Manage? drop-down menu, then select ?Go?.
    8. If any items are checked, try unchecking them, then selecting ?OK?. This will disable Add-ins that may be causing the freezing.
    9. Close Excel, then launch it normally to see if that did the trick. If not, repeat steps 3 through 7, only try a different selection in step 6. Go through the list in the drop-down for ?COM Add-ins?, ?Actions?, and ?XML Expansion Packs? and see if disabling items in those selections do the trick.


    If, this method doesn?t work. Go through the below URls for your reference and the better solution:

    https://support.microsoft.com/en-us/...5-4ca6853a1ff4

    https://www.stellarinfo.com/blog/fix...ponding-error/

    Best Regards,
    Steve

+ 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. Freezing cells without freezing columns
    By jensslofstra in forum Excel General
    Replies: 2
    Last Post: 09-26-2018, 01:51 AM
  2. How to copy a Cell from Excel into Word, edit it as RTF and then save back in Excel
    By peterjgoodwin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2013, 06:42 PM
  3. Replies: 2
    Last Post: 08-04-2012, 11:28 AM
  4. Why can't I edit my excel document? Edit buttons shaded.
    By David McRitchie in forum Excel - New Users/Basics
    Replies: 31
    Last Post: 09-06-2005, 08:05 PM
  5. [SOLVED] Why can't I edit my excel document? Edit buttons shaded.
    By Arl @ CBC in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. Why can't I edit my excel document? Edit buttons shaded.
    By Arl @ CBC in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Why can't I edit my excel document? Edit buttons shaded.
    By Arl @ CBC in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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