+ Reply to Thread
Results 1 to 8 of 8

Excel locks up

  1. #1
    Forum Contributor
    Join Date
    04-15-2008
    Location
    Texas, USA
    MS-Off Ver
    M365 Excel Version 2210
    Posts
    198

    Excel locks up

    I am CONSTANTLY in Excel to the extent that I may have 4 or 5 workbooks open at once. As well, I am bouncing back and forth between them, Gmail and MS Edge to various sites looking things up. Seems like every day, I click back onto one the Excel sheets only to find out Excel is locked up and nothing can be done any more on any workbook. I end up having to close out of everything and reboot so that I can continue working in Excel.

    Does anyone have any ideas as to why this happens and maybe how to get moving again without having to reboot?

    Thanks for any ideas.
    RR

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Excel locks up

    Hi, when you say 'Locks up' what do you mean, that it's 'not responding' or really stuck?
    And Reboot, what the entire system or just Excel? You can generally kill the Excel process using the Task Manager
    Which version of Excel are you using?
    Are these files macro embedded and if so do you have Workbook_Deactivate or Workbooks_Activate events running?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    04-15-2008
    Location
    Texas, USA
    MS-Off Ver
    M365 Excel Version 2210
    Posts
    198

    Re: Excel locks up

    Hi and thanks for your reply.

    When I say "locks up", what I am referring to is that when I have one or many Excel workbooks open and click on a web site or some other program then come back to the Excel workbook, when I click on it, nothing happens. It doesn't record key strokes to enter text or edit a formulas or even move around the file.

    I am using a Lenovo laptop with Windows 10 and Excel 2016. I am usually not working in files with macro but if so, they are not running any events.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Excel locks up

    Very strange, I don't recognize it and I often have many workbooks open and switch to Edge or other to lookup something but no lockups, do you have any AddIn installed or something similar?

  5. #5
    Forum Contributor
    Join Date
    04-15-2008
    Location
    Texas, USA
    MS-Off Ver
    M365 Excel Version 2210
    Posts
    198

    Re: Excel locks up

    I have no AddIns.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,073

    Re: Excel locks up

    Have you tried reinstalling Excel/Office, or repairing the installation?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Contributor
    Join Date
    04-15-2008
    Location
    Texas, USA
    MS-Off Ver
    M365 Excel Version 2210
    Posts
    198

    Re: Excel locks up

    No, but t looks like that may be my next thing to do.

    Thanks

  8. #8
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Excel locks up

    How's the diskspace on the Laptop?
    Clear cache and temporary files, check Registry with for example CCCleaner

+ 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. Accessing Add-In locks Excel
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2016, 02:27 PM
  2. select sql row with locks using excel
    By jtwork in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2008, 04:07 PM
  3. Save as locks up Excel
    By Greg Q in forum Excel General
    Replies: 1
    Last Post: 04-24-2006, 02:40 PM
  4. [SOLVED] Excel Locks Up
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 02-13-2006, 04:45 PM
  5. [SOLVED] Excel locks up when trying to save
    By The-Bee in forum Excel General
    Replies: 3
    Last Post: 01-04-2006, 09:10 PM
  6. Excel Locks up at end of Sub
    By Hugenstein in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2005, 09:54 AM
  7. [SOLVED] pcanywhere locks up excel
    By ccart123 in forum Excel General
    Replies: 0
    Last Post: 08-23-2005, 04:05 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