I have an Excel workbook created in Excel 2010. When I upload documents to SharePoint for my company it automatically populates document properties for the organization.
I have a workbook that I have password protected from opening and also added Structure protection to. When I added the structure protection and closed out it deleted the default document properties that SharePoint requires and therefore leaves the workbook checked out to me until I re-add the properties and check it back in.
What is causing it to remove the properties and how do I rectify this so it stops happening?