While getting ready to send some data to a customer I wanted to be sure any comments or personal data was fully removed. I was sure Office had a way to pull this office, but, was not quite sure of what it was. So, I Googled this:
Remove hidden data and personal information from Office documents
In the end it proved to be pretty simple:
Select File > Prepare > Inspect Document.
If the file has been modified since the last time it was saved you will be prompted to save the document before running the Inspection.
After the file has been saved, you will be prompted to check for seven different types of content:
Comments and Annotations
Document Properties and Personal Information
Custom XML Data
Headers and Footers
Hidden Rows and Columns
Hidden Worksheets
Invisible Content
Click Inspect after selecting (or deselecting) any pertinent content simply click the Inspect button. If issues are located, the dialog will prompt you.
You can rerun after opting to remove content and saving.
