My 2p about ERP Solutions, Information Worker Solutions and other software products (mainly Microsoft Dynamics AX and Microsoft SharePoint).

19 January 2009

Invalid look-up value durig upload of a Word document in a SharePoint document library

by Patrik Luca 9 comments


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:

  1. Open the Word 2007 document and click the Office 2007 button, located on the top-left of the window.
  2. Choose Prepare –> Inspect Document, which will start the Document Inspector.
  3. Check the box Document Properties and Personal Information, which will inspect hidden metadata saved with the document.

  4. Choose Inspect.
  5. 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.

Comments 9 comments
Riyas said...

Hi friend, your blog doing great! please tell me how you enabled post summaries ( continue reading) in this template. I dont get it. only gets title in the home page!

Patrik Luca said...


please take a look at Selective Expandable posts: I managed to achieve the post summaries by following these guidelines.

kreideicky said...

Hi, I have a situation in which the upload of a document from one library to another raises the same exception. I'm doing this programmatically in code. Both libraries have the same set of content types and I located the problem to be in one of the user fields I have in the content types. Is there a way to clear the metadata properties by code?

Anonymous said...


Thank you for posting the solution to the "Invalid look-up value" error. I work with SharePoint a lot, and this situation has poped up repeatedly. I finally decided to find out what to do about it and found your blog in the search.

Excellent, to the point instructions. Thank you!


Anonymous said...

T H A N K Y O U !

Boston, MA

Anonymous said...

Thank a lot..

Ganesan said...

Thanks a lot. It was very useful and saved much time.

Anonymous said...

Thanks, it worked perfectly.

Anonymous said...

Spot on advice. Thanks for your blogging.

Patrik Luca, Ieper, BELGIUM
Feel free to use or spread all of the content on my blog. In return, linking back to my blog would be greatly appreciated. All my posts and articles are provided "AS IS" with no warranties.

Subscribe feeds via e-mail
Subscribe in your preferred RSS reader

Subscribe feeds rss Most Read Entries

Subscribe feeds rss Recent Entries


Recommended Books

Subscribe feeds rss Recent Comments

This Blog is part of the U Comment I Follow movement in blogosphere. Means the comment field of this blog is made DOFOLLOW. Spam wont be tolerated.

Blog Archive

My Blog List