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 2


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:

  1. Isolate the error by removing columns from the view one at a time until you find the column that is causing the issue.
  2. Remove special characters from the field name
  3. 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.

  • Hi Tom,I tried to install above KB article but got "There are no products affected by this package installed on this system".
    – shreyas
    Oct 21, 2013 at 18:14
  • What version of SharePoint are you running?
    – Tom Resing
    Oct 22, 2013 at 1:05
  • SharePoint 2010
    – shreyas
    Oct 25, 2013 at 6:23
  • 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?
    – Tom Resing
    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.
    – shreyas
    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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.