EXCEL - Active Workbook Goes Uneditable - Hit Enter / Jumps to another workbook - Have to click back

%3CLINGO-SUB%20id%3D%22lingo-sub-215482%22%20slang%3D%22en-US%22%3EEXCEL%20-%20Active%20Workbook%20Goes%20Uneditable%20-%20Hit%20Enter%20%2F%20Jumps%20to%20another%20workbook%20-%20Have%20to%20click%20back%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215482%22%20slang%3D%22en-US%22%3E%3CP%3EVery%20seasoned%20in%20Excel%20-%20problem%20started%20with%20my%20last%20laptop%2C%20assumed%20the%20problem%20was%20there%20and%20could%20never%20resolve.%20Problem%20is%20now%20occurring%20on%20brand%20new%20computer%2C%20cannot%20find%20any%20solutions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOccasionally%20while%20working%20in%20my%20active%20workbook%2C%20I'll%20no%20longer%20be%20able%20to%20edit%20cells%20or%20use%20arrows%20to%20move%20cells.%20I'll%20click%20on%20any%20cell%2C%20hit%20ENTER%2C%20and%20another%20inactive%20window%20that%20was%20open%20will%20come%20up%20and%20it%20will%20revert%20to%20the%20last%20open%20cell%20there%20as%20if%20I%20was%20hitting%20ENTER%20on%20that%20workbook.%20I%20click%20back%20to%20the%20original%20workbook%20and%20the%20problem%20is%20resolved.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20becomes%20a%20huge%20annoyance%20when%20it%20happens%20multiple%20times%20an%20hour%2C%20in%20the%20middle%20of%20my%20workflow%20-%20disrupting%20it%2010-20%2B%20times%20a%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-215482%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1584094%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20-%20Active%20Workbook%20Goes%20Uneditable%20-%20Hit%20Enter%20%2F%20Jumps%20to%20another%20workbook%20-%20Have%20to%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584094%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F164637%22%20target%3D%22_blank%22%3E%40Ryan%20David%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20question.%20For%20a%20while%20I%20thought%20I%20was%20imagining%20the%20switch.%26nbsp%3B%20I'm%20able%20to%20fix%20it%20if%20I%20close%20the%20workbook%20that%20it%20is%20switching%20to%20and%20then%20reopening%20it%2C%20if%20it%20is%20one%20that%20I'm%20using.%20I%20would%20like%20to%20know%20the%20official%20cause%20and%20solution%20but%20I%20haven't%20found%20it%20yet.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1651207%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20-%20Active%20Workbook%20Goes%20Uneditable%20-%20Hit%20Enter%20%2F%20Jumps%20to%20another%20workbook%20-%20Have%20to%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1651207%22%20slang%3D%22en-US%22%3E%3CP%3EGlad%20to%20know%20I'm%20not%20the%20only%20one%20having%20this%20problem.%26nbsp%3B%20I%20am%20a%20power%20user.%26nbsp%3B%20I'll%20have%20multiple%20large%20files%20open%20in%20Excel%20along%20with%20files%20in%20Word%2C%20Adobe%20and%20Teams.%26nbsp%3B%20I've%20learned%20that%20if%20Excel%20%22stops%20responding%22%20to%20make%20note%20of%20what%20I%20was%20editing%20and%20hit%20the%20Enter%20key.%26nbsp%3B%20Excel%20changes%20focus%20to%20another%20file.%26nbsp%3B%20I%20haven't%20noted%20that%20whether%20it%20is%20in%20edit%20mode%20for%20the%20focus%20cell%20or%20not.%26nbsp%3B%20I'll%20hit%20Escape%20and%20then%20return%20to%20the%20file%20I%20was%20working%20on.%26nbsp%3B%20I%20have%20not%20seen%20a%20cumulative%20effect%20causing%20any%20of%20the%20open%20file%20to%20become%20corrupt...%20crossing%20my%20fingers%20on%20that%20one.%26nbsp%3B%20So%20it%20is%20%22just%22%20an%20annoyance%20that%20needs%20an%20explanation.%26nbsp%3B%20It%20is%20also%20a%20recent%20change%20in%20the%20behavior%20of%20Excel%2C%20so%20I'm%20guessing%20an%20update%20happened%20that%20isn't%20quite%20stable.%26nbsp%3B%20That%20doesn't%20bode%20well%20for%20the%20future.%26nbsp%3B%20Hopefully%20Microsoft%20development%20is%20paying%20attention.%26nbsp%3B%20However%2C%20it%20is%20interesting%20to%20note%20the%20original%20post%20was%20from%202018.%26nbsp%3B%20So%20maybe%20not%20new...%20just%20new%20to%20me.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F757035%22%20target%3D%22_blank%22%3E%40robbimj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1651322%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20-%20Active%20Workbook%20Goes%20Uneditable%20-%20Hit%20Enter%20%2F%20Jumps%20to%20another%20workbook%20-%20Have%20to%20click%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1651322%22%20slang%3D%22en-US%22%3EIt%E2%80%99s%20been%20happening%20now%20for%20years%20-%20multiple%20computers%2C%20multiple%20installs%2C%20even%2032%20vs%2064%20bit%20Excels%20-%20I%E2%80%99ve%20just%20accepted%20it%20as%20a%20glitch%20that%20I%20can%E2%80%99t%20solve.%20I%E2%80%99m%20super%20heavy%20on%20excel%20so%20I%E2%80%99m%20probably%20pounding%20enter%20in%20frustration%20about%2030%20times%20a%20day%20to%20cycle%20to%20the%20random%20other%20window%20so%20that%20I%20can%20navigate%20back%20to%20the%20cell%20I%20was%20trying%20to%20edit.%20Infuriating%20that%20Microsoft%20hasn%E2%80%99t%20fixed%20this%20yet.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Very seasoned in Excel - problem started with my last laptop, assumed the problem was there and could never resolve. Problem is now occurring on brand new computer, cannot find any solutions.

 

Occasionally while working in my active workbook, I'll no longer be able to edit cells or use arrows to move cells. I'll click on any cell, hit ENTER, and another inactive window that was open will come up and it will revert to the last open cell there as if I was hitting ENTER on that workbook. I click back to the original workbook and the problem is resolved.

 

This becomes a huge annoyance when it happens multiple times an hour, in the middle of my workflow - disrupting it 10-20+ times a day.

 

Please help!

3 Replies
Highlighted

@Ryan David 

Thanks for your question. For a while I thought I was imagining the switch.  I'm able to fix it if I close the workbook that it is switching to and then reopening it, if it is one that I'm using. I would like to know the official cause and solution but I haven't found it yet. 

Highlighted

Glad to know I'm not the only one having this problem.  I am a power user.  I'll have multiple large files open in Excel along with files in Word, Adobe and Teams.  I've learned that if Excel "stops responding" to make note of what I was editing and hit the Enter key.  Excel changes focus to another file.  I haven't noted that whether it is in edit mode for the focus cell or not.  I'll hit Escape and then return to the file I was working on.  I have not seen a cumulative effect causing any of the open file to become corrupt... crossing my fingers on that one.  So it is "just" an annoyance that needs an explanation.  It is also a recent change in the behavior of Excel, so I'm guessing an update happened that isn't quite stable.  That doesn't bode well for the future.  Hopefully Microsoft development is paying attention.  However, it is interesting to note the original post was from 2018.  So maybe not new... just new to me.  @robbimj 

Highlighted
It’s been happening now for years - multiple computers, multiple installs, even 32 vs 64 bit Excels - I’ve just accepted it as a glitch that I can’t solve. I’m super heavy on excel so I’m probably pounding enter in frustration about 30 times a day to cycle to the random other window so that I can navigate back to the cell I was trying to edit. Infuriating that Microsoft hasn’t fixed this yet.