03-15-2019 06:36 AM
03-15-2019 06:36 AM
We use a shared Excel Online worksheet that is concurrently accessed by approx. 50 users. The tabs are all named by date and we keep about 3 months of dates available at any time. Periodically, the current date's tab will move for no reason to somewhere random (could be in an earlier or later date tab position). The user's get confused when they are trying to find the current date and have to hunt through all the tabs to find it. We then have to manually drag it back to its correct place in the tab timeline. No one can recreate the problem. Is there a setting we can turn on to activate tab locking? Or has there been a problem reported in the past that a fix exists for? Thanks in advance for your help....
04-18-2019 01:45 AM
I've had this problem reported by an number of teams in our organisation. No idea why or how it's happening. I came on here to see if there was any information.
04-18-2019 04:54 AM
@tstrueby , you may open that workbook in desktop client and protect the structure (Review->Protect Workbook)
That could be a bug, but having up to hundred sheets ans 50 users they could move sheets unintentionally from time to time, it's easy to drag jumping from one sheet to another.
04-18-2019 01:35 PM
Thanks, @Sergei Baklan ! I took a rip at the Protect Workbook option on my desktop Excel and it does look like it will accomplish what I want to do. Thanks for that tip!
However, I still think there is some obscure key combination in Excel Online that causes tabs to move around unexpectedly. I am confident that our user base is not intentionally dragging sheets to random locations but I cannot recreate the key sequence that causes it.
I have seen times in this Excel Online worksheet when the cursor is not the standard pointer shape but is instead stuck in the "pointing finger" shape which is exactly the same shape it is when you hold down the left mouse button to drag a tab around in the worksheet. I am not sure what causes the cursor to suddenly change to this pointing finger shape but I do know that once it is in that shape and you click on a different tab of the worksheet, the current sheet you have open moves next to the tab you just clicked. That is almost certainly what is causing the issue but I cannot recreate the situation that causes the cursor to suddenly switch to a frozen pointing finger (sorry for the deep level of technical jargon on this description!).
Any thoughts on this theory and a possible cause/resolution?
05-22-2019 03:39 AM
@Sergei BaklanI'm having the same issue however I can't lock the workbook this way as other users in my organisation need to add tabs. Not only do tabs randomly move somewhere else in the workbook but when we open a workbook, the view is an inactive part of a random tab with empty cells.
When working offline previously we could save a workbook on the appropriate section of a tab and the recipient would see this when they open. I cannot work out how to do the same with the online version.
05-22-2019 03:12 PM
@Sergei BaklanI've encountered the same problem, and I've been searching for a solution for months. I'm one of only two users in the spreadsheet where it happens most frequently, so I am certain it's not another user moving tabs. Like the OP I've tried to recreate the problem but have been unsuccessful. I'll be in one tab, entering data, then I'll click over to another program (check my email, for example). When I click back to Excel Online, I'm still in the same tab. But as soon as I click a different tab, the old tab moves next to the new tab I clicked on, and I'm forced to drag it back where it belongs. Locking the sheet isn't an option for me, as worksheets must be added and removed frequently.
Just wanted to add my voice to others having this problem.
11-05-2019 10:55 AM
@tstrueby They seem to rearrange themselves in alphabetical order. I have a spreadsheet with six tabs in two week intervals. I've found that adding an "a" "b" "c" to the beginning of the dates keeps them in the correct order. Hope this helps!
11-06-2019 08:11 AM
@DocControlJessUnfortunately, that doesn't help. In fact, I'm actively *trying* to keep my worksheets in alphabetical order ... that's how I know (and why it's so frustrating) when Excel Online suddenly moves one. Just yesterday I was working along and everything was fine. I clicked into another window and worked in Outlook for awhile - when I returned to Excel Online the "Vistar" worksheet I'd been working in (that had been sitting between "Varidesk" and "Xerox" was suddenly up with my "C" vendors - between the "Canteen" and "Convergint" tabs. Super frustrating trying to drag it back where it belongs when working with multiple tabs (sheets) in one workbook.