Unable to retrieve all data

Leave a comment

October 26, 2016 by Ruaan Harmzen

We recently ran into some issues where we could not export a Sharepoint 2010 list OR successfully edit it in datasheet view. Even though the list is fairly big we have not issues with other lists of the same size.

When exporting to Excel we get the error:

An unexpected error has occurred. Changes to your data cannot be save.

When editing in datasheet view we get the error:

Cannot connect to the server at this time. You can continue working with this list, but some data may not be available.

Some content online suggests the issues relate to AAM, date or people fields. We tried the various suggestions with no luck. In the end our solution was to remove the grouping on the view. The list in question had a grouping on 2 fields and after removing it we could export and edit in datasheet view.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: