Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

Hi Iam getting an error like "An unexpected error has occurred. changes to your data cannot be saved " while I was trying to open a list using excel (after clicking export to Excel in Ribbon).

share|improve this question
Hi Ram, I am not sure if I understood your sentence. Is it that you first exported the list into excel and while opening the excel file you are encountering the error? Or you first exported the list into excel and now when you are going back to access the list in sharepoint, you are experiencing the error? – spStacker Jul 11 '12 at 19:40
We need more information to answer your question. Please edit your post and add details as requested by the community. It will be closed for now, but don't worry - once you have improved the question flag a moderator and it can be reopened. See our FAQ for general guidelines. – SPDoctor♦ Aug 10 '12 at 12:16

closed as not a real question by SPDoctor♦ Aug 10 '12 at 12:16

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 0 down vote

Maybe it has to do with the actual data. SharePoint is extremely picky about the format of the data in the spreadsheet. Row 1 must be column titles, and the data must start at row 2. Try troubleshooting this issue by creating a very simple spreadsheet with just 2 or 3 columns and 2 or 3 rows. See if you still get the error, then you'll have a better idea where the problem lies.

share|improve this answer

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