Error: A look-up field contains invalid data. Please check the value and try again

Question

Currently we are working in a process where documents are uploaded, then downloaded, modified and re-uploaded as a NEW file, not as a new version of the same file. However, When I upload the documnet, I get following error

I tried the following:

1. Found that there is a previous file uploaded, which was modified to make this new one.
2. Changed filename - didn't work, same error (though anyways there is no file with the same name)
3. In windows, I "removed all properties and personal information of the file" - didn't work, same error
4. Copied all sheets into a NEW workbook in excel - that did the trick.

The solution in point 4 is bit impractical as because it means that every now and then we will need to keep copying sheets to new excel files which will be tedious in the long run, so we need to look for a workaround.

Any help is appreciated.

Answer 1

Are you programmatically doing this?

Have you tried checking with Document Inspector for any corrupt/invalid properties??

http://ravikra.blogspot.ca/2012/04/problem-with-uploading-documents-to.html

regards, KS