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.
View my profile
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!
my email:riyas504@gmail.com
Hi,
please take a look at Selective Expandable posts: I managed to achieve the post summaries by following these guidelines.
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?
Thanks!
Patrik,
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!
JW
NC, USA
T H A N K Y O U !
Christy
Boston, MA
USA
Thank a lot..
Thanks a lot. It was very useful and saved much time.
Thanks, it worked perfectly.
Spot on advice. Thanks for your blogging.
Post a Comment