Issue Sorting/Filtering Excel Spreadsheet ONLINE with multiple people editing

Question

Hello,

We've been experiencing an intermittent issue when a user tries to sort or filter an Excel spreadsheet ONLINE while others are also in the spreadsheet.

We have multiple people (avg. 4-8 people at any given time) editing the speadsheet daily and at the same time. Everyone accesses the file for editing via website. Everyone has Office 365 and computers are up to date. There's usually not any issues but, occasionally the spread sheet will not sort or filter correctly and we can't figure out what is causing it to happen. It's an intermittent issue that has happened at least once a week for the past few weeks.

Has anyone else had this happen? What's the problem?

Answer 1

Hi Lina,

Thanks for using Microsoft products and posting in the community, I'm glad to offer help.

When collaborating in a spreadsheet, we recommend everyone use the Sheet View feature to create personal views so that users won't be disrupted by others when editing the spreadsheet.

For more information about Sheet View, please refer to Sheet Views in Excel - Office Support (microsoft.com)

And please feel free to let me know if you have any concerns, I'll continue to help you.

Best Regards,

Arck

Answer 2

Hello. Yes I found the info you provided to be very helpful. Thank you!

Answer 3

Hi Lina,

I'm writing this reply to follow up on this thread, may I know I you have checked the above replies? And if you still need help here, please feel free to come back and let us know.

Stay safe and have a nice day : )

Best Regards,

Arck

Answer 4

Hello,

We've been experiencing an intermittent issue when a user tries to sort or filter an Excel spreadsheet ONLINE while others are also in the spreadsheet.

We have multiple people (avg. 4-8 people at any given time) editing the speadsheet daily and at the same time. Everyone accesses the file for editing via website. Everyone has Office 365 and computers are up to date. There's usually not any issues but, occasionally the spread sheet will not sort or filter correctly and we can't figure out what is causing it to happen. It's an intermittent issue that has happened at least once a week for the past few weeks.

Has anyone else had this happen? What's the problem?

When you say:

We have multiple people (avg. 4-8 people at any given time) editing the speadsheet daily and at the same time.

exactly and specifically what is the definition of the word "Editing"

does it mean:

updating (adding new data)

updating (replacing old data with new new data)

updating (removing old data)

There should not be any activity on the shared workbook to manipulate the dataset to induce any changes in the representation of the dataset such as filtering or sorting (affects calculations on references to the dataset).

If there is anyone doing such an activity then that is a big problem for everyone.