0

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.

0

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

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.

  • 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 '13 at 18:14
  • What version of SharePoint are you running? – Tom Resing Oct 22 '13 at 1:05
  • SharePoint 2010 – shreyas Oct 25 '13 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 '13 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 '13 at 21:32
0

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, privacy policy and cookie policy

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