Forum Discussion
Tabs in Excel Online worksheet move unexpectedly
So, I finally figured this out I believe, at least for us. When you open an Excel Doc in a web browser, and click on a tab, it automatically puts you in "move tab". You have to click twice on a tab to switch to it without being in "move tab". Not sure if this is an Excel bug or a Browser bug (Chrome in my case). But protecting the workbook structure fixes it, or just using it in desktop mode.
I just noticed the same. I'm having the same issue and realized the sheets kept moving even while trying to reorganize them by date. Single clicking the sheet name automatically turns on the "reorder tab".
I'm having the same problem. Just started today after months of building this online workbook. Tabs have a mind of their own, all of a sudden. They rearrange their order randomly. I am wasting a lot of time putting them back in order. Microsoft tech support blamed my ISP (first tech) and my browser (second tech). I doubt both.
- Hi. We are experiencing the very same issues with tabs moving unexpectedly and random empty cells being selected when clicking on a new tab. Doesn't seem to happen when opening in the full app but many users prefer to use the browser version when working quickly through Teams (using Chrome). The other issue I've also come across is that where we have set up some columns with data validation to use a British date format (dd/mm/yyyy), when opening Excel in the browser version it will tend to only accept mm/dd/yyyy (ie the US format) even though data validation is still turned on. Very frustrating at times and again only seemingly cured by opening the full app. Will try the Protect Workbook idea but that may reduce some of our desired functionality. Interested to hear any other experiences or solutions.
jimluck I use a MacBook pro 2014. If I just touch the trackpad (to select a worksheet) the tabs then move order, however when I firmly press the trackpad the worksheet I want is selected but the tabs are fixed in place. I hope that helps.
- Only works sometimes. I've done both and I thought the solution was exactly as you said. But I am "clicking" the tabs and the same "reordering" is happening whether clicking or just tapping the track pad.
