Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We have a custom list that we are trying to edit in Datasheet view and are getting the following error when the next row is clicked:

Another user has changed the structure of this list. All your pending changes to this list will be discarded. To retrieve the latest copy of the list, click Refresh.

Obviously, clicking Refresh causes all changes to be discarded. Items can be entered by using the New Item form without issue. I have also verified that there are no calculated columns in the view and that the values we are trying to insert contain no commas. I have also verified that the choice columns do contain the values we are attempting to use.

Here is the structure of this list: List Columns

Here is the structure of the view: View Columns

Are we missing something obvious? Any suggestions would be greatly appreciated, thanks.

share|improve this question
    
Can you give us the complete URL of the list? I had that issue with a list that had a special character in its name... –  AlexPoint Jun 16 '11 at 7:11

2 Answers 2

up vote 1 down vote accepted

This might help: http://bmerri19.wordpress.com/2009/07/15/sharepoint-error-%E2%80%93-%E2%80%9Canother-user-has-changed-the-structure-of-this-list%E2%80%9D/

This is the content of the link:

SharePoint error – “Another user has changed the structure of this list” July 15, 2009 Recently while working on a recent SharePoint project, we ran into a problem when multiple users were editing a list item in the Datasheet view. We started seeing the following error below:

After searching online I found some solutions that recommended removing check-box columns from the view, however this did not work for me. I eventually opened up a case with Microsoft Services Premier Support (thanks Josh!) and we finally tracked this down to another column that contained a comma in the hyperlink URL (to a pdf drawing in another library):

http://sharepointserver/site/drawings/Colorado Springs,%20Colorado.pdf

Renamed the pdf drawing to not include the comma, added the updated hyperlink to the list item and no more error when editing other fields in a datasheet! This was pre SP2, so I don’t know if the issue still exists after installing SP2 or any cumulative rollups.

share|improve this answer
    
Unfortunately, I am unable to see that page due to corporate blocking. I am probably not the only one with this problem when it comes to Wordpress. Would you please edit your answer to include both the link and a summary of the solution presented? Thanks! –  theChrisKent Dec 22 '11 at 13:33
    
hi, I added the text. –  Mor Shemesh Jan 10 '12 at 14:30

I've seen this before where a title column, for example, is required but hidden in the datasheet view. In your case it looks like both of the required columns are exposed on the datasheet view, so I'm assuming you are entering them.

One thing you might consider is deselecting the columns one at a time from the datasheet view until it works. This will help you determine which column is causing the error and maybe give you a better idea what is going on.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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