I have workbooks that when opened, will often not select the correct cells by mouse click. For example, I can hover my mouse and click K30, but K5 is selected.
I've noticed that this happens only after scrolling. In fact, if I scroll the document back to its original view when opened, the selection within that view works correctly.
Once the document is scrolled, when I click, the selected cell appears to be the cell that would have been there if the document had never been scrolled.
To recap, if I open the document and do not scroll, select K30 with the mouse, then K30 is highlighted correctly. If I scroll the view down 10 rows, highlight K30 again (which has moved up 10 rows on the screen), then now K20 will be highlighted (even further up the screen).
Any ideas? Usually closing and reopening the program a few times fixes the glitch.
I've noticed that this happens only after scrolling. In fact, if I scroll the document back to its original view when opened, the selection within that view works correctly.
Once the document is scrolled, when I click, the selected cell appears to be the cell that would have been there if the document had never been scrolled.
To recap, if I open the document and do not scroll, select K30 with the mouse, then K30 is highlighted correctly. If I scroll the view down 10 rows, highlight K30 again (which has moved up 10 rows on the screen), then now K20 will be highlighted (even further up the screen).
Any ideas? Usually closing and reopening the program a few times fixes the glitch.