+ Reply to Thread
Results 1 to 3 of 3

Sheet freezes until I click outside the sheet then back in

  1. #1
    Registered User
    Join Date
    11-17-2022
    Location
    Vancouver, BC
    MS-Off Ver
    Microsoft 365 Apps for Business
    Posts
    7

    Sheet freezes until I click outside the sheet then back in

    This doesnt happen predictably so it's difficult to get help. When I'm working within (any) spreadsheet, the sheet will freeze. I click on another window, any window, then back onto the sheet and it works again for a while. It also often doesn't highlight the cell I'm in but if you look at the cell contents on the ribbon you can see that you're in the right cell. I also often get an error message that there is a problem with the copy paste but then it goes ahead and pastes like I asked it to. We've uninstalled and reinstalled office but I'm not sure where to go from here. I'd like to blame my machine but everything else is working fine. I do a lot of work in Google Sheets as well with no issues. Has anyone else had to deal with anything similar? TIA.
    Last edited by Ravenpg; 01-25-2023 at 01:55 PM.

  2. #2
    Forum Contributor
    Join Date
    08-12-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 16
    Posts
    241

    Re: Sheet freezes until I click outside the sheet then back in

    When it goes into the freeze, does it recover after a time? The next time it "freezes" look at the bottom bar to the right to see if it is actually in the processing mode. It will display a % to show how far into the process it is.
    What you are describing is typical of this. If you click elsewhere, it will continue, but the % will remain and in fact, take longer to resolve because you are adding more computations to it. It will generally do this when your spreadsheet has become large, or you have another large spreadsheet open, or you have many sheets open.
    -Squeaky

  3. #3
    Registered User
    Join Date
    11-17-2022
    Location
    Vancouver, BC
    MS-Off Ver
    Microsoft 365 Apps for Business
    Posts
    7

    Re: Sheet freezes until I click outside the sheet then back in

    Thank you! I'll have a look next time it happens.

+ 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. Sheet Locks Up/Freezes Sometimes When Clicking back over from VBA Editor?
    By Norcal1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-22-2019, 12:13 PM
  2. Input on sheet 1, to the next sheet, then back to sheet 1 - im lost
    By wonderingman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-30-2019, 05:14 AM
  3. [SOLVED] Finding two values from Sheet 1 on Sheet 2 and pulling back a 3rd value from Sheet 2
    By sneve23 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 03-31-2017, 12:14 PM
  4. Double click row to return data to userform for edit then return back to sheet
    By MattRSJ in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-31-2014, 06:05 AM
  5. Option button click ... then focus back to sheet ?
    By dannac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 02:05 AM
  6. Focus back to the Excel Sheet I started on after the Database Updates on a sheet.
    By ca1358 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-21-2011, 11:44 AM
  7. [SOLVED] Multiple Freezes in a sheet
    By amag in forum Excel General
    Replies: 3
    Last Post: 11-21-2005, 04:50 AM

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