Showing posts with label Office 2007. Show all posts

Thursday, September 18, 2014

SharePoint 2010: Office Documents missing properties missing

Issue

A user has a issue saying whenever they any password protected document on SharePoint such as word, Excel or Power Point Document their document properties went missing.

Error

There is no error however, when you view properties of any SharePoint document they will be missing.

Background

User had three mandatory fields on a SharePoint document library. When editing the document after checkout, it allows him to select the properties and save the document. However, when he refreshes his SharePoint Library, the document properties went missing.

Environment

Windows 7, Office 2010 and SharePoint Server 2010.

Troubleshooting

Created a document with the password protection and uploaded to SharePoint and if did clears out the properties.

Tried doing this with the password protection and its working fine.

Tried the same things on other types of documents and is showing the same behaviour.

Resolution

My last post explains the reason for this http://mossnwss.blogspot.co.uk/2014/01/document-properties-are-clearing-out.html.

Microsoft claims that this is the by design behaviour that when you protect any document with encrypted password it will protect the meta data associated with the document.

However there is workaround suggested by Microsoft.

Start –> Run –> regedit

Navigate to HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\14.0\common\security

Note
Version 14.0 is shown if you have Office 2010. Office 2007 will be 12.0, and Office 2013 will be 15.0.

Note
You might have to create a few keys

Look for the property OpenXMLEncryptProperty. If it is not there, create it as a REG_DWORD. Set the value to 0.

References

Applies to

SharePoint server 2010, Office 2007, Office 2010.

Thursday, January 23, 2014

Document properties are clearing out when uploading document to SharePoint site: SharePoint 2010.

Issue: Document properties are clearing out when uploading a Powerpoint document to SharePoint site.

Background: We had a user who has an issue where he uploads a PowerPoint document with some predefined properties in place enforced by the clients IT security team.

These properties are nothing was just a categorization of the document in different ways. The issue was when user checkout the document, edit the document and then check in back the document all the properties associated with the document was washed/vanished (you can call it whatever you want…).

Hmm, Interesting. This only happening to PowerPoint document, rest all documents were opening fine without any issue.

Troubleshooting:

It seems to be very heavy issue to me. At first instances it was filling something to be wrong with PowerPoint document on the local desktop.

We cleared all the properties of the document, uploaded on SharePoint check-out, edited it, check-in back but still the problem is same.

We tried the same steps with excel, word type documents and its working fine.

Replicated the issue on a different site by saving the list as a template without content and it was reproduced i.e. properties are getting clearing out again and again.

Uploaded a test PowerPoint on the site and it was working fine.

Uploading new document is working fine but issue is occurring on the old documents.

Resolution:

There was no clear point which could tell why this issue is occurring, however, the one thing which was very basic to check but ignored. The problem document was a password protected. When removed and uploaded it was working fine. Properties was not clearing out.

We tried the reverse on other documents i.e. protected the excel and word documents with password and uploaded to SharePoint, uploading , checkout, editing, check-in back and it again brought issue back.

So it was clear that password protection was giving issue on the documents properties clearing out.

Now the question was why this is happening? Is because password protection use encryption and with the encrypted properties SharePoint doesn't understand the properties values and make then blank.

You have to choose the properties again by editing the document properties to again categories them.

You can educate user of your company by spreading this work in the internal SharePoint forums by creating FAQ’s etc.

If you are not aware how to enable and disable password protection on office documents, below is the link:

http://office.microsoft.com/en-gb/help/password-protect-documents-workbooks-and-presentations-HA010148333.aspx

TechNet Wiki Link:

Applies to: MOSS 2007, SharePoint Server 2010, Office 2007, Office 2010.

Wednesday, August 29, 2012

This document could not be registered. It will not be possible to create links from other documents to this document

Problem Description:

Consider the Following situation:

You create a file or have a file that has the maximum allowed characters in the filename of that file on a Microsoft Windows 7 computer.

Note: This size limitation incudes the path to the file as well as the filename.

When you try and open the file with Microsoft Word 2003, 2007 or 2010 you get the error "This document could not be registered. It will not be possible to create links from other documents to this document"

Probable cause:

The filename and path is too large. The maximum filename and path size is 255 characters.

Resolution:

To work around this issue the filename will have to modify to a shorter length. This issue occurs because of a 255-character limitation on creating and saving files in the Office products. Also, you receive an error message when you save or open a file if the path of the file meets the following condition for the appropriate program.

This will be applicable for word2003, word2007 as well as word2010.

If you have any queries/questions regarding the above mentioned information then please let me know.

I would be more than happy to help you as well as resolves your issues, Thank you J

Amardeep Singh's SharePoint Blog

Blogroll