<div>
Do you have &quot;Remove personal information from file properties on save&quot; checked? If so, then clear it.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/10_w43/1123220/Excel2013_RemovePersonalInformation.png" target="_blank" title="Excel default - Remove personal information from file properties on save (81 KB)"><img alt="Excel default - Remove personal information from file properties on save" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/10_w43/800_1123220/Excel2013_RemovePersonalInformation.png" /></a>&gt; &quot;What is causing it to remove the properties and how do I rectify this so it stops happening?&quot;<br />
Maybe what you are being given is a copy made by putting sheets in a new workbook and that is why property settings aren't transferring ... hard to guess.
</div>


Excel default - Remove personal information from file properties on save

Excel2013_RemovePersonalInformation.png

<div>
@crystal I did check that option and it is NOT turned on. That was the only thing I could think of that would cause that to happen but that is not the case. Thank you for the suggestion.
</div>


<div>
you're welcome<br />
<br />
this is something that seems to be saved with the file .. check again when that file is open
</div>


<div>
I did check on the file itself, not just Excel. That is the first thing I checked when things started to go wrong and that feature is not checked on that Excel workbook.
</div>


<div>
the only reason I ask is because (just today!) I discovered that option was set after opening a workbook I created several months ago. &nbsp;I have turned it off since then. &nbsp;Today, it was back on!
</div>


<div>
No one was able to give me an answer and the system said the question was abandoned.
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
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. <br />
<br />
What is causing it to remove the properties and how do I rectify this so it stops happening?
</div>
</div>


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?

SharePoint 2010 removing required document properties from structure protected Excel 2010 workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

A Document Management System (DMS) is a system (both hardware and software) used to track, manage and store documents and reduce paper. Most are capable of keeping a record of the various versions created and modified by different users (history tracking). It is often viewed as a component of enterprise content management (ECM) systems and related to digital asset management, document imaging, workflow systems and records management systems.