Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

If I have more than one worksheet open while entering data in one spreadsheet it won't let me enter data and I have to click in another worksheet and go back before I can enter data again.
Solved by B. L. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/05/2018 - 02:26
Hello, I understand that you are not able to enter data into a worksheet when you have another worksheet open, right?
User 14/05/2018 - 02:27
Yes, I'll be entering data and then it is like the spreadsheet is gone, and I have to click in a different worksheet and then go back in to the one I was working in to enter data again.
Excelchat Expert 14/05/2018 - 02:28
Okay, if I understood you correctly then the only way this can happen is if you are on edit mode in another worksheet. This is why when you go back to the other worksheet and you click on something, it suddenly works.
Excelchat Expert 14/05/2018 - 02:29
By clicking on the other worksheet, you are effectively going out of edit mode which is why you are then able to edit your actual worksheet.
Excelchat Expert 14/05/2018 - 02:29
Edit mode is when you are editing a cell with a formula or typing something in a cell.
Excelchat Expert 14/05/2018 - 02:30
In other words, the focus is still in the other worksheet and Excel won't let you do anything until you commit or cancel the edit mode.
Excelchat Expert 14/05/2018 - 02:34
Are you still with me?
User 14/05/2018 - 02:35
Yes, so how is that fixed?
Excelchat Expert 14/05/2018 - 02:36
It can't be fixed because that is by design. That was intentional by Microsoft.
Excelchat Expert 14/05/2018 - 02:36
It won't allow you to edit another workbook unless you finish editing the other workbook first.
Excelchat Expert 14/05/2018 - 02:36
So basically, you'll just have to make sure that you are done editing or outside of the edit mode before switching to another worksheet.
User 14/05/2018 - 02:36
that's weird, I'm only opening 2 worksheets.
Excelchat Expert 14/05/2018 - 02:37
It doesn't really matter how many worksheet or which ones you have opened.
User 14/05/2018 - 02:37
I'm working in one, and then I have to go back and forth. It's a real pain.
Excelchat Expert 14/05/2018 - 02:37
You can press ESC before switching to the new one.
Excelchat Expert 14/05/2018 - 02:37
And yes, it's a real pain but unfortunately, that is how Microsoft designed Excel.
User 14/05/2018 - 02:38
I'll have to try that. Microsoft obviously does not work with multiple worksheets open - if they did, they would fix it.
Excelchat Expert 14/05/2018 - 02:39
Please note that pressing ESC will cancel any ongoing edit you are doing so make sure you commit your edit if you need to by pressing ENTER instead of ESC when you want to.
Excelchat Expert 14/05/2018 - 02:40
But basically, all that is needed here is to ensure that you are not currently editing any cell before you move to the other worksheet.
Excelchat Expert 14/05/2018 - 02:40
I'm sure you'll get used to it soon enough.
Excelchat Expert 14/05/2018 - 02:40
I work with multiple Excel files on a daily basis and while I still see myself with the same problem as yours, I've learned how to deal with it and it doesn't bother me anymore.
Excelchat Expert 14/05/2018 - 02:41
But yeah, I understand your pain. I lose momentum when I work and this happens. :D
User 14/05/2018 - 02:43
It drives me bonkers... the amount of time I lose going back and forth between the worksheets is frustrating
User 14/05/2018 - 02:43
but thanks for the info
User 14/05/2018 - 02:43
I'll try the esc next time.
Excelchat Expert 14/05/2018 - 02:44
You are welcome. I wish I could do more though but it's really in the core design of Excel so there's nothing much we can do.
Excelchat Expert 14/05/2018 - 02:44
Would there be anything else that I can help you with regards to the original question?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc