It can be very annoying if your Sharepoint administrator has added a policy to always show the Document Information Panel when you open a Sharepoint file.
You have to keep closing the Document Information Panel every time you open a file. And you can't even deselect the "Always show Document Information Panel on document open and initial save" because they disable that checkbox!!
Word and Excel can automatically hide this pesky Document Information Panel using macros.
In your normal.dotm file (located in C:\Users\%Username%\AppData\Roaming\Microsoft\Templates\), add the following two functions to the macros (Alt-F8 to open Macros window).
Sub AutoOpen() ' ' AutoOpen Macro ' ' Application.OnTime Now + TimeValue("00:00:03"), "ToggleDocumentPanel" End Sub Sub ToggleDocumentPanel() With Application .DisplayDocumentInformationPanel = False End With End Sub
This one's a bit more tricky.
Sub Auto_Open() ' ' Auto_Open Macro ' Remove Document Information Panel ' Application.OnTime Now + TimeValue("00:00:03"), "ToggleDocumentPanel" End Sub Sub ToggleDocumentPanel() With Application .DisplayDocumentInformationPanel = False End With End Sub
8. Save the excel spreadsheet.
9. On the View tab, click Hide Window.