How can you remove personal information from a workbook before sharing it with others?

The most direct and comprehensive method to remove personal information and other hidden data before sharing a workbook is by using the Document Inspector. This tool is found under File > Info > Check for Issues > Inspect Document. It scans the workbook for various types of data, including comments, document properties (like author), hidden worksheets, and other potentially sensitive information, and provides an option to remove them. This one-time check is the standard procedure for preparing a document for distribution.

A. "Protect Workbook" prevents structural changes to the workbook, such as adding or deleting sheets, but does not remove personal data.

B. This option describes a non-existent feature in Excel's right-click menu for recent workbooks; this functionality is not available there.

D. While this Trust Center setting does remove personal information from file properties on save, the Document Inspector is the more comprehensive tool that also finds and removes other hidden data like comments, annotations, and hidden content, which is crucial before sharing.

1. Microsoft Official Documentation: "Remove hidden data and personal information by inspecting documents

presentations

or workbooks." Microsoft Support. Accessed May 2024.

Section: "Use the Document Inspector to find and remove hidden data and personal information." This section explicitly states

"Before you share a copy of your Office file... it's a good idea to use the Document Inspector to find and remove any hidden data and personal information that you might not want to share." It then details the process of using the tool via File > Info > Check for Issues > Inspect Document.

2. University Courseware: University of Wisconsin-Madison

DoIT KnowledgeBase. "Microsoft 365 - Inspecting a Document for Hidden and Personal Information."

Section: "Inspecting a Document." This guide instructs users to "Go to File > Info. Click on the Check for Issues button and select Inspect Document" as the primary method for removing hidden and personal information from Office files

including Excel workbooks.

3. University Courseware: Gettysburg College

IT Documentation. "Removing Personal or Hidden Information from a Microsoft Office File."

Section: "How to Remove Hidden Data and Personal Information." This document outlines the procedure: "The Document Inspector helps you find and remove hidden data and personal information in Office documents... To open the Document Inspector

click File > Info > Check for Issues > Inspect Document." This reinforces that the Document Inspector is the designated tool for this task.