This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello
My business is using excel online in conjunction with Forms. Our Excel workbooks are saved on SharePoint sites and entries are made to the worksheets by means of online Forms which are submitted by our staff in the field. A number of users in our office need to have access to and be able to edit the worksheets at the same time and I do not want them to have to open the workbook on the excel desktop app. This all works very well. However, I need to be able to prevent users from sorting the data in the worksheets using the sort function. When I open the workbook in the desktop app I can do this by protecting the workbook and unchecking the 'sort' option in the list of allowed activities and allowing a group ('Everyone') to edit all cells by using the allow users to edit ranges function. This has the effect I am looking for while the workbook is open in the desktop app but when the workbook is saved and opened through SharePoint no cells can be edited (ie, the 'allow users [group = everyone] to edit ranges' settings I applied in the desktop app are not taking effect).
Can anyone help me with this please? Put simply, I want to be able to disable the sort function for excel online opened via SharePoint without affecting the ability of users to edit online
Thank you
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I'm sorry, I won't be able to help you further with this issue. Another expert should reply shortly.
Thank you again for your reply but this is also unrelated to my problem.
Hello DH-HW,
Hope this link will help you resolve your issue.
https://support.google.com/docs/thread/10622718...
Please let me know if you have any further question.
Regards,
John
Thank you for your reply. But, having read the thread you referred to, it does not answer my question. I am not having a problem with people opening the spreadsheets offline.
What I am trying to achieve it to prevent users from applying 'sort' to the spreadsheets.
Hi,
I am John, Independent Advisor here to work with you on this issue.
As per your reference, this link from uservoice might help you resolve your issue: https://excel.uservoice.com/forums/274580-excel...
Should you have any questions, please feel free to let me know.
Thank you,
John