One of my colleagues asked me to check an error message while uploading a word document to the document library in SharePoint 2010 today.  I just looked at the message, it so wired and I haven’t seen before. Actually I am not a SharePoint admin but.. 😉

Here is the error:

“Invalid lookup-value. A look-up field contains invalid data. Please check the value and try again”

After spending few minutes I have got some idea about this problem, actually my colleague was trying to upload the document which was downloaded from another SharePoint (2007) environment and it has all the previous  “Document Server Properties” (ie. Metadata columns). Here are the possible other inspections for this error.

To solve this issue, just click the Document Inspector and remove all inspected properties of the document and upload again. You can find the steps for the 97-2003 Word document here. I am going to show you the steps for 2010 word document (.docx).

Please Note these two points from MSDN:

• If you remove hidden content from your document, you might not be able to restore it by clicking Undo.
• If you want to remove hidden data and personal information from documents you save in the OpenDocument Text (.odt) format, you must run the Document Inspector every time you save the document in this format.

Step 1: Open the document and click File –> Info

Step 2: Click Check for Issues drop down in the middle pane and choose Inspect Document

Step 3: You will get the following window and Click Inspect button (if you want to remove only the “Document Server Properties” then just click the option only)

Step 4: You will see all the inspection results on the window and then click Remove All on the right side & Close.

After this, you will be able to upload the document. That’s all guys, Happy uploading..!

This is a very quick post, if you find any issues just let me know. 🙂 Thanks. R./

References:

http://office.microsoft.com/en-us/word-help/inspect-documents-for-hidden-data-and-personal-information-HA010074435.aspx#BM2