Mar 20 2022 09:29 AM
Mar 20 2022 09:29 AM
This is an ongoing issue that I've been having for years across platforms, computers, versions of excel and workbooks.
Basicially, one of two things happen:
1-I click on a cell but nothing happens, the cell is not selected
2-I click on a cell but the wrong cell is selected (Example: Click on cell B2 but excel will select C2)
This will happen as frequently as a few times a day (across multiple workbooks) to every month (again, across multiple workbooks)
In ALL cases cells are NOT protected
Saving the workbook, closing then restarting excel fixes the problem.
As I mentioned before, this has been ongoing for years now across multiple computers, workbooks, operating systems. All systems and versions of excel were fully up to date at the time of the error. Because this is happening over several different workbooks, I do not belive it is a workbook issue (especially when it doesn't happen 100% of the time to ANY workbook)
Macbook Pro (circa 2015), OS up to date - No longer have this computer
Windows 8 (again, old computer)
Windows 10 (old computer
Windows 11 (2 different computers, currently owned)
I have always kept excel and the OS fully up to date and I'm currently using the most recent version of Windows and Excel.
In all cases, I have used built in trackpad and a 3 different wireless mice (with full batteries). Still randomly occurs.
It's really just an annoyance and like I mentioned before, saving the workbook and restarting excel solves the issue... until next time (which could be later that day or a few weeks...It's very random.)
Mar 21 2022 06:24 AM
According to what has been written, edit mode might be activated.
But without a file (without sensitive data) it is difficult to make assumptions, especially in this case where it goes through many Excel versions.
If it is not, many questions arise beforehand.
Does it only happen in this file?
Does this file have macros?
Are add inns enabled?
Have all updates been carried out?
Has an Office repair been performed?
Anyway, hope this information helped you a bit.
I know I don't know anything (Socrates)
Mar 21 2022 08:07 AM
Mar 21 2022 08:35 PM
Please find below the thread for the same error that you’re facing:
Sep 13 2022 08:07 AM
The function row that used to show up automatically in previous Excel versions appears not to be in MS365. I type and edit text quite frequently in Excel. I am unable to click text in a cell to correct a typo. This is incredibly frustrating and step in the wrong direction in my opinion.
Oct 05 2022 02:15 AM
I am also facing the same issue with one of my systems which is currently running Office 2019 and Windows 11.
Oct 05 2022 05:02 AM
Oct 22 2022 11:19 AM
Oct 22 2022 11:39 AM
Nov 21 2022 02:37 PM
Has there been a solution to this? This started happening to me after Windows 11 update. When panes are frozen and I click on a cell it randomly selects another cell. For now clicking another sheet and going back to your worksheet seems to "fix" it, but it keeps happening.
Nov 21 2022 04:04 PM
No fix for me. Windows, Excel and all drivers are up to date on the THREE computers I'm experiencing the issue. It does seem to be some sort of "focus" issue with my pointing device (mouse on desktop, mouse and trackpad on laptop #1 and trackpad on laptop #2). Clicking in some other window "works" every time...until next time. I have not found a consistent reason as to why it's been happening. Once I had the issue on a clean install of windows on a blank sheet!
Nov 23 2022 11:51 AM - edited Nov 23 2022 11:53 AM
@CPeterson710 - There is an excel bug that is supposed to be fixed with the Oct update that relates to using a touch pad to zoom and scroll.
But I see this is happening with mice as well.
Nov 25 2022 05:54 AM
Dec 20 2022 09:56 AM
Feb 09 2023 03:48 PM
@CPeterson710 I turned my (new) mouse off and I seem to be able to select cells using my trackpad now. I was having the same issue even with my trackpad while the mouse was turned on. It's an ergonomic "Perixx" mouse, Model No. Permice-608, for what it's worth.
Feb 12 2023 12:32 PM
I had faced this issue some time back on one of my laptops, and cannot recall, but managed to circumvent it. Have now started facing the same issue since a fortnight on my laptop with Windows 11 and Excel 2019, and it is driving me crazy. Clicking on another window and back into excel works, most often. Clicking on menubar and then into cells also works sometimes. But nothing works consistently, and it is killing my productivity big time. Someone please help!
Feb 13 2023 06:27 AM
Mar 17 2023 08:54 AM
Mar 20 2023 05:42 PM
Mar 20 2023 06:23 PM