I have a list with two views 1.data sheet view 2.standard view. users are able to edit datasheet view and standard view. The issue is when users want to edit Standard view in data sheet they are unable to edit it and gets an error like "An unexpected error has occurred. Changes to your data cannot be saved." Please let me the know any solution if you have.
There are a number of causes for this error, so here are a few different situations that may apply.
Change the Columns
Try one of the following two methods:
- Isolate the error by removing columns from the view one at a time until you find the column that is causing the issue.
- Remove special characters from the field name
- Undeclare as a record
For SharePoint 2007, there is a hotfix available that applies to that error:
For SharePoint 2010, it's been reported that Service Pack 1 addresses some issues that may be related.
users are not having correct permissions to the list. hence they are unable to edit the items in data sheet view.