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: