Friday, June 29, 2007

Exception (0x81071003): Unable to update the information in the Microsoft Office document

When adding a document (Excel) to SharePoint I get the exception: "(0x81071003): Unable to update the information in the Microsoft Office document".

The exception occur in a ItemAdded event handler where I add a global unique human-readable document id to the document.

This most likely due to an error in the property promotion/demotion part of SharePoint.

If I try to open up the Excel sheet myself I get an error as inline VBA code cannot be executed. So if SharePoint tries the same no wonder it doesn't work. But how can you block promotion/demotion in such situations.

Edit the document, (in Office 2003) Go to File, Properties, Custom Properties then choose any property like client and type any value, then click add then close the dialog and save the document. After this you should be able to upload/save the document in the document library without problems.

1) The issue was with property promotion/demotion of this file while saving metadata during check-in process.2) I saved this file as .XLSX in 2007 format and uploaded it; I successfully checked in the file.3) Then I downloaded this copy on my local system; opened it and saved it in .XLS format.4) This copy was then uploaded and successfully checked in to the library in question. (all the metadata properties were pre filled in advance from the earlier .XLSX file downloaded from SP site); hence any issues related to property promotion and demotion were removed.

I have this problem too. I was able to fix it using OLE Automation object which removes all custom properties of the document. But I can't do anything when I haven't MS Word installed. Maybe somebody knows how to get rid of these fields?