Troubleshoot sorting and filtering in Datasheet view
I cannot save the sort order or filter criteria in the view.
Any sorting or filtering that you apply to a list after opening it in Datasheet view is not saved. When you close the view or switch to another view, the settings are lost. To save a sort order or filter criteria, specify them as part of the view definition.
The sort and filter commands are not available.
If a column does not support sorting or filtering, the commands are not displayed when you click the column header.
Some of the operators are missing in the Custom Filter dialog box.
The list of operators displayed in the Custom Filter dialog box varies with the data type of the selected column. For example, Begins with and Contains are not available for numeric columns.
I cannot see the column on which I want to sort rows or filter data.
Make sure the column is not hidden in Datasheet view. Right-click the cell in the top left corner of the list, and click Unhide. If the Unhide command is disabled, then check the view definition to make sure the column is included in the view.
The sort order does not match the settings on my computer.
This could be due to the regional settings on your SharePoint server.
For more details, see Microsoft Windows SharePoint Services Help. To display Windows SharePoint Services Help, click Help on the page toolbar.
I applied a filter or sort but the view does not appear filtered or sorted.
When you add or edit data after applying a filter or sort, the view does not automatically refresh the data. Try refreshing the view, or reapply the filter or sort order.