Issue when any 2+ worksheets are open

Microsoft Word 2013 32/64-bit
June 12, 2019 at 06:32:18
Specs: Windows 7 x64, 2,4 GHz / 4 GB
I am not sure if I will be able to explain this very well but here goes:

So I have 2 excel files open, it doesn't matter if they have formulas or not, but they usually do - that's what most of us use Excel for, right? :)

- I write in the 1st file in 1 cell, then in another I want to select the formula and copy it and suddenly I can't select the formula
or
- I was writing in a cell and midway it started writing like in a mirror somehow, letters appearing from the right of the cell to the middle - I was writing the word laboratory, and after lab, the cursor remained after the letter b and letters started appearing to the right but not in the correct order
or
- sometimes I can't write at all in a cell, it simply won't type anything

If in one of the situations above I press ENTER, the other excel file gains focus and sometimes the text I was trying to write in the 1st file is written in the 2nd file in some cell, sometimes not. After I minimize the 2nd excel everything works fine for a while, but then it happens again, regardless of what kind of cell I have selected in the 2nd file (blank, text, formula cell).

I'm assuming for some reason Excel loses focus of the 1st file and gets focus of the 2nd, but why?

I don't even know how to google this - believe me, I've tried!
I hope I explained it clearly.

Did anyone else encounter such an issue?
Is anyone able to find the cause and/or a solution?

Thanks in advance.

message edited by Mrrrr


See More: Issue when any 2+ worksheets are open

Reply ↓  Report •

#1
June 12, 2019 at 07:57:50
Since it sounds like you are having this problem with more than just a specific pair of files, the first thing I would suggest is what any Level 1 tech support representative would suggest:

Close all files and restart your computer. Power down completely and start from scratch.

If the problem still exists, then you might want to consider running the MS Office repair utility:

https://support.office.com/en-us/ar...

Other than that, I don't have a clue, especially if it happens with any and all "pairs" of files, new and old. The support link above also discusses how to uninstall and reinstall office. Hopefully you won't have to go that route.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
June 12, 2019 at 08:12:07
I vaguely recall that there have been some problems where changing the Zoom level has helped, but can't remember what the exact problem was. Might be worth a try.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#3
June 12, 2019 at 10:32:40
IIRC the "zoom level" fix was related to the issue of multiple cells being selected when the user only wanted to select a single cell. It was as if the selected range was "stuck" to the mouse pointer and followed it around wherever you dragged to mouse. Changing the zoom level allowed you to free up the pointer, so to speak.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Related Solutions

#4
June 12, 2019 at 11:34:15
DerbyDad03: Power down completely and start from scratch.
Careful with this advice. Starting with Win8, attempting to shutdown a PC actually hibernates it, making a restart more effective than a shutdown.

Mrrrr:
Could be, but is probably not, some rouge VBA. Try running Excel with macros disabled.
Could be some third party add-on that wasn't properly tested. Try running Excel in safe mode.

How To Ask Questions The Smart Way


Reply ↓  Report •

#5
June 12, 2019 at 12:20:40
Razor2.3: Careful with this advice. Starting with Win8, attempting to shutdown a PC actually hibernates it, making a restart more effective than a shutdown.

Wouldn't that depend on your definition of a "shutdown"? If I'm not mistaken, there are multiple ways to actually close Win8 and power down the device. That's my definition of a "shutdown".

Could be, but is probably not, some rouge VBA.

I'd like to see the macro that does this: <vbg>

"...letters appearing from the right of the cell to the middle - I was writing the word laboratory, and after lab, the cursor remained after the letter b and letters started appearing to the right but not in the correct order"

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#6
June 12, 2019 at 12:56:51
DerbyDad03: If I'm not mistaken, there are multiple ways to actually close Win8 and power down the device.
All but two actually hibernate it. Those two are WMI's Win32_OperatingSystem.Win32Shutdown(), and SHUTDOWN.EXE. Technically anything that directly calls ExitWindowsEx() can do a shutdown "for real" which means any third party program is generally good, but that's neither here nor there.

DerbyDad03: I'd like to see the macro that does this
Honestly, so would I.

How To Ask Questions The Smart Way


Reply ↓  Report •

#7
June 13, 2019 at 06:32:49
Razor2.3: Could be, but is probably not, some rouge VBA.
This has happened to my boss too and she has no macros in her Excel. I do have lots of code, but since it's happening to her I am guessing it is not VBA-related.

Razor2.3: Could be some third party add-on that wasn't properly tested.
She has no add-ons either, besides the ones installed by default, if any. I have some add-ons, including some made by me, but this doesn't happen every day and to every 2+ excel files. It's a random thing.

DerbyDad03: If the problem still exists, then you might want to consider running the MS Office repair utility
Couldn't, even if I'd want to. IT department must be called in this case. I like to think I can find the cause of this without having Office solve it for me, without even knowing what it was. Ultimately, I will take this advice.

DerbyDad03: [...] reinstall office. Hopefully you won't have to go that route.
Couldn't, even if I'd want to. IT department must be called in this case. I like to think I can find the cause of this without having Office solve it for me, without even knowing what it was. Ultimately, I will take this advice if Repair doesn't work.

DerbyDad03: Close all files and restart your computer. Power down completely and start from scratch.
This I did, even if only after ending the working day.

As I said above, it seems to be randomly happening. For example, today I had no problems, but yesterday I had.

So I might have to write down what files I had the problem with, see what cells were selected in each of the files, analyze other characteristics of the files (no idea which of course) and then see if I can find the issue.

I was asking this because I thought some other people might have encountered such an issue and found at least a cause if not also a solution.

message edited by Mrrrr


Reply ↓  Report •

#8
June 13, 2019 at 07:50:28
Well, something is changing focus, and if there's an IT department involved, it's probably external to Excel. Some background, IT installed program that messes with keyboard focus, and doesn't restore it correctly once its done.

How To Ask Questions The Smart Way


Reply ↓  Report •

#9
June 14, 2019 at 12:03:53
Could be, but the weird thing is that it seems to be happening only to Excel.
I'm gonna try and watch out for those pesky little IT programs too, thanks for the tip.

Reply ↓  Report •

#10
June 14, 2019 at 12:30:37
If you can do without your own macros for awhile,
try running Excel in Safemode for a time.

SafeMode:
Forces Excel to bypass all files in the Application Data\Microsoft\Xlstart folder, the default XLStart folder located in the directory where Excel or Office is installed, and the alternate startup file location specified on the General tab of the Excel Options dialog box. It also forces Excel to bypass the toolbar file (Excel.xlb or <username>.xlb). You see "Safe Mode" in the Excel title bar.

If you still get the problem in Safemode then it is probably as Razor2.3 suggested,
something IT has going on.

For Safemode, in the Run Box enter: excel.exe /s

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#11
June 15, 2019 at 23:27:33
I will try this too, thanks.

Reply ↓  Report •

Ask Question