Sep 18 2021 12:43 PM
Working out of several workbooks when all the sudden you entering numbers and it switches workbooks on it own.. is this ever going to be fixed?
Sep 19 2021 10:18 AM - edited Sep 19 2021 10:22 AM
@thetxrider wrote: Working out of several workbooks when all the sudden you entering numbers and it switches workbooks on it own.. is this ever going to be fixed?
If there is a common problem and it is needing to be fixed, it would begin with a lot clearer description of what's happening, i.e., what exactly are the symptoms, where does it happen (and where does it not happen), when does it happen (and when does it not happen), how often, how severe, etc.
But given that, around the world as I write this, and as you wrote your question, there are thousands (perhaps millions) of users of Excel working with several workbooks open, entering numbers in one -- and apparently NOT experiencing the same thing--the probability that Excel needs fixing on this issue is pretty small. Very close to zero.
So, let me share my own experience and then ask you a question or two:
You see, just as a doctor needs a very precise and detailed set of symptoms in order to diagnose accurately, the same is true in getting to the bottom of an alleged problem with Excel (or any other piece of software). And, frankly, it's extremely unlikely that Excel itself is going to be the culprit when a user is doing something so prosaic as filling in numbers in one of several workbooks open at the same time.