Top of PageI cannot save the sort order or filter criteria in the view
The sort and filter commands are not available
Some of the operators are missing in the Custom Filter dialog box
I cannot see the column on which I want to sort rows or filter data
The sort order does not match the settings on my computer
I applied a filter or sort but the view does not appear filtered or sorted
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.
If a column does not support sorting or filtering, the commands are not displayed when you click the column header.
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.
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.
This could be due to the regional settings on your SharePoint server.
For more details, see SharePoint Foundation 2010 Help. To display Help in SharePoint Foundation 2010, click Help (
).
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.