If you are sharing your workbook with others then you should review the workbook for personal information or hidden data that may be stored & later on reveal the important information like company name, author, etc. As this information is more than sufficient for other person to figure out the kind of work is going on, in short to secure the data to be shared publicly, you may want to remove the hidden information each time you share the workbook with other person.
If your workbook is saved as a shared workbook you cannot remove comments, annotations, document properties and personal information. To get rid of this information from a shared workbook, unshared the workbook.
In this article we will let you understand how the Document Inspector feature in Excel can help you in removing hidden data and personal information in your workbooks.
To prevent this information from a workbook being shared publicly with other people you can follow the below steps:
The next time you will open the workbook you will not find personal information.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.