How to remove all personally identifiable information from an Excel file.
When a file is created in Excel, it automatically stores data about you and your computer setup as well as other information related to the creation and management of the document. The worst part is that you may not even know this is happening because the data is not stored in the spreadsheet but in the data for the file itself.
Let's remove all personal data from Excel so we can safely send our files out to anyone.
Now, if I look to the right of the File menu screen again I can see that the Properties, Author, and Last Modified By information was removed.
This will not remove any personal information that has been stored inside of cells in a spreadsheet in Excel. This method only removes the hidden personal information that is stored in the data for the file itself (it's not actually hidden but it's not visible in the normal worksheet interface).
If you download the accompanying workbook, you will see what a "cleaned" file's properties look like.