Sharepoint - How to remove Document Information Properties

Question

_{Tuesday, January 15, 2019 7:11 PM}

I am trying to remove the Document Information Properties within Excel.  Every time I open a document that is pulling data from Share Point, it displays the Document Information Properties.  It's not a big deal to click on the X and close it.  But it's annoying to do that every time I open excel.

Here is what I have done so far to try and remove it.

1.  I logged into our SharePoint site and did the following:

Library settings - Clicked on Document under Content Types - Document Information Panel settings -

There wasn't a check on the following:

Require that the document properties are displayed automatically when using Microsoft Office products that are compatible.

2. Opened the excel document and clicked on the Developer Tab - Then clicked on Document Panel.

Always show Document Information Panel on document open and initial save -  The option is checked but I cannot uncheck it because it's greyed out.

3.  Deleted the following registery key and open the excel document again.

HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Open Find\Microsoft Excel\Settings\Add Document Information Panel

Did not fix the issue.

Can someone please let me know how to fix this annoying feature?

Thank you!

All replies (2)

_{Wednesday, January 16, 2019 2:31 PM ✅Answered}

Lisa,

Thanks for looking into this issue for me.  I mentioned that I already made sure the Document Information Panel settings box was unchecked.  I found it odd that it was NOT checked, so I did not need to make any changes.

I think this has to do with a GPO on the network. Any documents that are from SharePoint have this issue.

I found a work around though.

The fix was to auto run a macro that hides the document information panel.  I tested it out and every time time I open the document, the document information panel closes or hides.

Here's what I did:

Click on the Developer tab in Excel.

Click on Visual Basic

Put the code below to “ThisWorkbook"

Sub Workbook_Open()
    DisableDocumentInfomationPanel
End Sub

Sub DisableDocumentInfomationPanel()
    CheckStatus
End Sub

Put the code below to a module:

Public Sub CheckStatus()
     If Application.DisplayDocumentInformationPanel = True Then
         Application.DisplayDocumentInformationPanel = False
     End If
     
     Dim alertTime As Date
     alertTime = Now + TimeValue("00:00:02")
     Application.OnTime alertTime, "CheckStatus"
 End Sub

_{Wednesday, January 16, 2019 9:52 AM}

Hi BryGuy77, 

I have done a test in my SharePoint 2010 with office 2010. 

Go to Library settings - Clicked on Document under Content Types - Document Information Panel settings uncheck the box: Always show Document Information Panel on document open and initial save for this content type.

When I open excel file, the document information panel is not displayed. 

For

orrDoes

For your issue, make sure the excel is document content type. 

Are you working in SharePoint 2010 with office 2010?

Does the issue exists in other libraries?

Does the issue exists in other documents in the same library? try to upload a new excel file as document content type in the library and compare the results? 

Best Regards, 

Lisa Chen 

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.