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.
2 Answers
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
Patch
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.
answered Oct 20, 2013 at 19:06
-
Hi Tom,I tried to install above KB article but got "There are no products affected by this package installed on this system".– shreyasCommented Oct 21, 2013 at 18:14
-
-
-
The hotfix I referenced above addresses the "An unexpected error has occurred. Changes to your data cannot be saved." issue for SharePoint 2007. It should already be a part of 2010. Are the columns shown in both of your views the same? Commented Oct 28, 2013 at 19:07
-
Standard view is having just 40% of the fields/columns of Data sheet view. on Standard view I have a look up field which is not present on Data sheet view.– shreyasCommented Oct 28, 2013 at 21:32
users are not having correct permissions to the list. hence they are unable to edit the items in data sheet view.