Problem description: invalid look-up value during upload of a Word document
During upload of a Word 2007 document in a SharePoint document library, you can run into following error: Invalid lookup-value. A look-up field contains invalid data. Please check the value and try again.
Solution: remove the Document Properties with the Document Inspector
Probably, the Word document you are trying to upload is a Word document downloaded from another SharePoint document library. The source, original document library has probably other metadata (columns) than the document library to which you are trying to upload the Word document.
To fix this, remove these hidden metadata with the Document Inspector:
- Open the Word 2007 document and click the Office 2007 button, located on the top-left of the window.
- Choose Prepare –> Inspect Document, which will start the Document Inspector.
- Check the box Document Properties and Personal Information, which will inspect hidden metadata saved with the document.
- Choose Inspect.
- Choose Remove All. This will remove all Document server properties and Content type information saved with the Word document.
Aferwards, you’ll be able to upload the Word document to your own SharePoint document libary.