Forum Discussion

tstrueby's avatar
tstrueby
Copper Contributor
Mar 15, 2019

Tabs in Excel Online worksheet move unexpectedly

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...
excel
Excel Online
DocControlJess's avatar
DocControlJess
Copper Contributor
Nov 05, 2019

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!

  • CScott20's avatar
    CScott20
    Copper Contributor
    Apr 07, 2020

    DocControlJess 

    I don't know if you will still get this but please could you explain your workaround?

  • D_Fifer's avatar
    D_Fifer
    Copper Contributor
    Nov 06, 2019

    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.

    • JSMCA's avatar
      JSMCA
      Copper Contributor
      Apr 15, 2020
      Agreed. Definitely NOT kept in alphabetical order.

Resources