If you plan to distribute a workbook to others, you may want to have Excel check the file for hidden data and personal information. This tool can locate hidden information about you, your organization, or about the workbook that you may not want to share with others.
To do so, choose Office => Prepare => Inspect Document.
Click Inspect, and Excel displays the results of the inspection and gives you the opportunity to remove the items it finds.
If Excel identifies items in the Document Inspector, it doesn't necessarily mean that they should be removed. In other words, you should not blindly use the Remove All buttons to remove the items that Excel locates. For example, you may have a hidden sheet that serves a critical purpose. Excel will identify that hidden sheet and make it very easy for you to delete it. To be on the safe side, always make a backup copy of your workbook before running the Document Inspector.
No comments:
Post a Comment