Help Troubling issue. Rows randomly rearranging.

Has anyone noticed rows randomly rearranging?

I first noticed a few days ago, after dragging selected groups of rows and manually rearranging my sheet. (these groups are not parent child I just mean certain groups of rows I generally keep together and for some odd reason they appear to stay together but are still moved out of order in relation to other rows and "groups"). The next time I opened the sheet different groups were all in different locations. And I have also noticed randomly single rows appear to randomly be moved up the sheet several rows. This usually is rows from near or at the bottom moving up several rows.

I do have two shared users who would have had sheets open and making changes but they do not move rows around they only edit cells.

I also think it may have happened after moving multiple rows to other sheets.

Is this a common issue? I suspect it has to do with having multiple users with sheets open while manually making these changes.

Best Answer

Answers