Home

Tabs in Excel Online worksheet move unexpectedly

%3CLINGO-SUB%20id%3D%22lingo-sub-370078%22%20slang%3D%22en-US%22%3ETabs%20in%20Excel%20Online%20worksheet%20move%20unexpectedly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-370078%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20use%20a%20shared%20Excel%20Online%20worksheet%20that%20is%20concurrently%20accessed%20by%20approx.%2050%20users.%26nbsp%3B%20The%20tabs%20are%20all%20named%20by%20date%20and%20we%20keep%20about%203%20months%20of%20dates%20available%20at%20any%20time.%26nbsp%3B%20Periodically%2C%20the%20current%20date's%20tab%20will%20move%20for%20no%20reason%20to%20somewhere%20random%20(could%20be%20in%20an%20earlier%20or%20later%20date%20tab%20position).%26nbsp%3B%20The%20user's%20get%20confused%20when%20they%20are%20trying%20to%20find%20the%20current%20date%20and%20have%20to%20hunt%20through%20all%20the%20tabs%20to%20find%20it.%26nbsp%3B%20We%20then%20have%20to%20manually%20drag%20it%20back%20to%20its%20correct%20place%20in%20the%20tab%20timeline.%26nbsp%3B%20No%20one%20can%20recreate%20the%20problem.%26nbsp%3B%20Is%20there%20a%20setting%20we%20can%20turn%20on%20to%20activate%20tab%20locking%3F%26nbsp%3B%20Or%20has%20there%20been%20a%20problem%20reported%20in%20the%20past%20that%20a%20fix%20exists%20for%3F%26nbsp%3B%20Thanks%20in%20advance%20for%20your%20help....%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-370078%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-470389%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Excel%20Online%20worksheet%20move%20unexpectedly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-470389%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F301572%22%20target%3D%22_blank%22%3E%40tstrueby%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20had%20this%20problem%20reported%20by%20an%20number%20of%20teams%20in%20our%20organisation.%26nbsp%3B%20No%20idea%20why%20or%20how%20it's%20happening.%26nbsp%3B%20I%20came%20on%20here%20to%20see%20if%20there%20was%20any%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-470973%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Excel%20Online%20worksheet%20move%20unexpectedly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-470973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F301572%22%20target%3D%22_blank%22%3E%40tstrueby%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20open%20that%20workbook%20in%20desktop%20client%20and%20protect%20the%20structure%20(Review-%26gt%3BProtect%20Workbook)%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20581px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109452i25BBD78DB03EE710%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThat%20could%20be%20a%20bug%2C%20but%20having%20up%20to%20hundred%20sheets%20ans%2050%20users%20they%20could%20move%20sheets%20unintentionally%20from%20time%20to%20time%2C%20it's%20easy%20to%20drag%20jumping%20from%20one%20sheet%20to%20another.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-473235%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Excel%20Online%20worksheet%20move%20unexpectedly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-473235%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B!%26nbsp%3B%26nbsp%3BI%20took%20a%20rip%20at%20the%20Protect%20Workbook%20option%20on%20my%20desktop%20Excel%20and%20it%20does%20look%20like%20it%20will%20accomplish%20what%20I%20want%20to%20do.%26nbsp%3B%20Thanks%20for%20that%20tip!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20still%20think%20there%20is%20some%20obscure%20key%20combination%20in%20Excel%20Online%20that%20causes%20tabs%20to%20move%20around%20unexpectedly.%26nbsp%3B%20I%20am%20confident%20that%20our%20user%20base%20is%20not%20intentionally%20dragging%20sheets%20to%20random%20locations%20but%20I%20cannot%20recreate%20the%20key%20sequence%20that%20causes%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20seen%20times%20in%20this%20Excel%20Online%20worksheet%20when%20the%20cursor%20is%20not%20the%20standard%20pointer%20shape%20but%20is%20instead%20stuck%20in%20the%20%22pointing%20finger%22%20shape%20which%20is%20exactly%20the%20same%20shape%20it%20is%20when%20you%20hold%20down%20the%20left%20mouse%20button%20to%20drag%20a%20tab%20around%20in%20the%20worksheet.%26nbsp%3B%20I%20am%20not%20sure%20what%20causes%20the%20cursor%20to%20suddenly%20change%20to%20this%20pointing%20finger%20shape%20but%20I%20do%20know%20that%20once%20it%20is%20in%20that%20shape%20and%20you%20click%20on%20a%20different%20tab%20of%20the%20worksheet%2C%20the%20current%20sheet%20you%20have%20open%20moves%20next%20to%20the%20tab%20you%20just%20clicked.%26nbsp%3B%20That%20is%20almost%20certainly%20what%20is%20causing%20the%20issue%20but%20I%20cannot%20recreate%20the%20situation%20that%20causes%20the%20cursor%20to%20suddenly%20switch%20to%20a%20frozen%20pointing%20finger%20(sorry%20for%20the%20deep%20level%20of%20technical%20jargon%20on%20this%20description!).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20on%20this%20theory%20and%20a%20possible%20cause%2Fresolution%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-499337%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Excel%20Online%20worksheet%20move%20unexpectedly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-499337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EOh%20good%20tip%20about%20protecting%20the%20structure%2C%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632916%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Excel%20Online%20worksheet%20move%20unexpectedly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632916%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EI'm%20having%20the%20same%20issue%20however%20I%20can't%20lock%20the%20workbook%20this%20way%20as%20other%20users%20in%20my%20organisation%20need%20to%20add%20tabs.%20Not%20only%20do%20tabs%20randomly%20move%20somewhere%20else%20in%20the%20workbook%20but%20when%20we%20open%20a%20workbook%2C%20the%20view%20is%20an%20inactive%20part%20of%20a%20random%20tab%20with%20empty%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20working%20offline%20previously%20we%20could%20save%20a%20workbook%20on%20the%20appropriate%20section%20of%20a%20tab%20and%20the%20recipient%20would%20see%20this%20when%20they%20open.%20I%20cannot%20work%20out%20how%20to%20do%20the%20same%20with%20the%20online%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636113%22%20slang%3D%22en-US%22%3ERe%3A%20Tabs%20in%20Excel%20Online%20worksheet%20move%20unexpectedly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EI've%20encountered%20the%20same%20problem%2C%20and%20I've%20been%20searching%20for%20a%20solution%20for%20months.%20I'm%20one%20of%20only%20two%20users%20in%20the%20spreadsheet%20where%20it%20happens%20most%20frequently%2C%20so%20I%20am%20certain%20it's%20not%20another%20user%20moving%20tabs.%20Like%20the%20OP%20I've%20tried%20to%20recreate%20the%20problem%20but%20have%20been%20unsuccessful.%20I'll%20be%20in%20one%20tab%2C%20entering%20data%2C%20then%20I'll%20click%20over%20to%20another%20program%20(check%20my%20email%2C%20for%20example).%20When%20I%20click%20back%20to%20Excel%20Online%2C%20I'm%20still%20in%20the%20same%20tab.%20But%20as%20soon%20as%20I%20click%20a%20different%20tab%2C%20the%20old%20tab%20moves%20next%20to%20the%20new%20tab%20I%20clicked%20on%2C%20and%20I'm%20forced%20to%20drag%20it%20back%20where%20it%20belongs.%20Locking%20the%20sheet%20isn't%20an%20option%20for%20me%2C%20as%20worksheets%20must%20be%20added%20and%20removed%20frequently.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20wanted%20to%20add%20my%20voice%20to%20others%20having%20this%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E
tstrueby
New Contributor

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.... 

6 Replies

Hi@tstrueby 

 

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.

 

@tstrueby , you may open that workbook in desktop client and protect the structure (Review->Protect Workbook)

image.png

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.

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?

 

Thanks!    

 

@Sergei BaklanOh good tip about protecting the structure, thanks

@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.

@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.