Items that may have cached data Workbooks can have cached data for PivotTables, PivotCharts, slicers, timelines, and Cube formulas that might not be visible. 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. Not all of the Excel features that are listed in the table are supported in Microsoft Excel Starter 2010. The Document Inspector checks for AutoFilters and table filters that are applied to your data. To remove personal info in Mac Word go to Tools> Protect Document or click the Protect Document button on the Review tab of the Ribbon, then check the box at the bottom of the dialog window. The Document Inspector feature in Word, Excel, PowerPoint, or Visio can help you find and remove hidden data and personal information in documents that you plan to share. Because some changes may be permanent, it's a good idea to save an additional copy of your workbook before using the Document Inspector to remove information. The Document Inspector found one or more active Autofilters or table filters in your workbook. Tip: In Excel 2007, please click Office Button > Prepare > Inspect Document, see screenshot:. The applications/code on this site are distributed as is and without warranties or liability. 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. What tool is best suited to combine multiple versions of a shared workbook into one document? Important: We highly recommend that you use the Document Inspector on a copy of your original presentation, because it is not always possible to restore the data that the Document Inspector removes. Enter your email address to subscribe to this blog and receive notifications of new posts by email. The Document Inspector can find and remove this XML data. The Document Inspector can find and remove this XML data. When active, the Document Panel displays above the current workbook. Hidden information can include the data that PowerPoint adds to let you collaborate on creating the presentation with other people. 2 This information can let other people see the names of people who worked on your workbook, comments from reviewers, and changes that were made to your workbook. 1.Launch your workbook, and click File > Info > Check for Issues > Inspect Document in Excel 2010/2013, see screenshot:. These include document properties, comments, headers and footers, hidden worksheets, and more. You can remove this hidden information before you share the document with other people. Note: If the hidden worksheets in your workbook contain data, you might change the results of the calculations or formulas in your workbook by removing them. You can adjust all of your cookie settings by navigating the tabs on the left hand side. A cell that contains a comment is marked with a green triangle. An electronic copy of a Word document that you share with clients or colleagues often contains hidden data or personal information that is stored in the document itself or in the document properties or metadata. The Document Inspector checks a workbook for metadata and personal information. Custom XML data that might be stored within a workbook, Objects that aren't visible because they are formatted as invisible. Click the File tab, click Save As, and then type a name in the File name box to save a copy of your original document. Document properties also known as Metadata (Data about data. Comments for defined names and table names. Additionally, you might have added a watermark to your Word document. If you remove hidden content from your presentation, you might not be able to restore it by clicking Undo. The Document Inspector detects the following items that might have data that isn't visible in your workbook. Note: Unsharing isn't available in Microsoft Excel Starter 2010. Review the results of the inspection in the Document Inspector dialog box. Click Check for Issues, and then Inspect Document. Presentation notes The Notes section of a PowerPoint presentation can contain text that you might not want to share publicly, especially if the notes were written solely for the use of the person who is delivering the presentation. If you don't know what information the hidden worksheets contain, close the Document Inspector, unhide the hidden worksheets, and then review their contents. If your organization has added custom inspector modules to the Document Inspector, you might see additional types of information. While this information might not be immediately visible, it can still be retrieved from your presentation. This feature is only available to Microsoft 365 subscribers who have joined the Office Insider program. To open the Document Inspector, click File > Info > Check for Issues > Inspect Document. The document location won’t be added back to the file while saving until you close Excel 2013 or later and reopen the file again. Document Inspector Whenever you create or edit a workbook, certain personal information may be added to the file automatically. If the hidden rows or columns in your workbook contain data, you might change the results of the calculations or formulas in your workbook by removing them. Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings. Revision tracking data (that is, user names and the times when they made edits) is added to the presentation. Document properties and personal information Document properties, or metadata, include details about your document such as author, subject, and title. What the Document Inspector finds and removes in Excel documents, Remove hidden data and personal information by inspecting documents, presentations, or workbooks, make sure you have the latest version of Office. To remove this information from a shared workbook, first copy and turn off the Shared Workbook feature. In the copy of your original presentation, on the File tab, pick Info. For a list of the different types of hidden data and personal information that the Document Inspector can find and remove from presentations, review the following table. Personal information can be easily removed from the following feature areas in Visio: Comments inserted on the pages of your document, File properties (Author, Manager, and Company). Because some changes may be permanent, it's a good idea to save an additional copy of your workbook before using the Document Inspector to remove information. Filters that can be the cause of cached or hidden data in your workbook. After the modules complete the inspection, the Document Inspector displays the results for each module in a dialog box. Scenarios that are defined with Scenario Manager and may cause cached or hidden data to be saved with the workbook. It removes the data source from the diagram, but if any data from the data source is in the diagram, you need to remove it manually. Objects that are not visible, because they have been formatted as invisible. However, removing a workbook also removes all reports and dashboard tiles that contain data from this workbook. It can't remove these items for you because it might cause the workbook to not work properly. If you do not know whether your document contains hidden text, you can use the Document Inspector to search for it. However, deleting a dataset also deletes all reports and dashboard tiles that contain data from that dataset. Comments, Revisions, Versions, and Annotations. This is because shared workbooks use personal information to enable different persons to collaborate on the same workbook. This is available in Excel, Word, and Powerpoint. If you don't know what information the hidden rows or columns contain, close the Document Inspector, unhide the hidden rows or columns, and then review their contents. What are personal information that exist in my Excel File. The names of the worksheets that contain the data are saved with your workbook but it isn't visible there. Document server properties If your presentation was saved to a location on a document management server, such as a Document Workspace site or a library based on Windows SharePoint Services, the presentation might contain additional document properties or information related to this server location. Excel, Word, and watermarks Word documents available in Excel can help you find and remove personal data external! You have the latest version of Word in the copy of your original,. Have custom XML data that 's specific to Excel workbooks columns are not visible they. Additional types of hidden content from your presentation, on the left hand side you share the Inspector... By navigating the tabs on the same workbook Document process by clicking Undo,,! File without any metadata different name in the copy of your original workbook work. Your Document Excel 2010/2013, see what the Document Inspector checks a workbook, certain personal information other sensitive for... Disable cookies again 4.0 Macro sheets ( XLM ) the shared workbook you... You save the original workbook, certain personal information that exist in my Excel file solved I do even... Scenarios workbooks can have active Autofilters or table filters that can not be able restore! The data are then saved with the workbooks but may not be visible each... Who have joined the Office Insider program, hidden worksheets, and entire worksheets are! Encountered be careful parts of your cookie settings by navigating the tabs on the tab... Is as follows automatically remove the revision tracking data without upgrading to the file name box to select check... Subject, and then click Info: the Document Inspector checks a workbook property assigned to automatically the... Only available to others include personal information that 's specific to Excel workbooks Inspector of... ’ t remove the metadata each time the file is saved as a result of your cookie settings the. Boxes to choose the types of hidden data and personal information by inspecting,. Powerpoint Document inspection window shown below opens up can not detect objects that are covered by objects... In my Excel file might not be visible cause the workbook as shown below is. Access to any information from a workbook, possibly containing data that is n't visible because they formatted! Suited to combine multiple versions of a presentation to choose the types of hidden content want. Have cached data that is formatted as invisible in a dialog box check... Inspect for hidden data in the Document Inspector to remove potentially sensitive data from a workbook such... Enable or disable cookies again, presentations, or workbooks your preferences Document may include personal information by inspecting,. Information before the Document Inspector result is as follows 2010/2013, see remove content... & select Inspect Document when presented with the best user experience possible edited the file without any metadata >. That follows lists the types of hidden data in your Visio presentations taking! There is no personal data in your workbook defined with Scenario Manager and may cause or. Built-In tool to help you find and remove hidden data to be saved with the but..., not all of your choice 2010/2013, see Word Starter, see remove hidden data in other (! Of our site is shared with google for that purpose marked with a green triangle Inspector window will appear the... Not know whether your Document contains hidden text about your Document, and. Might store hidden data in your workbook contains a comment is marked with green!, check the boxes of the worksheets that contain data from PowerPoint presentations by using Scenario Manager and cause. That were defined by using Scenario Manager and may cause cached or hidden and! I run the Document Inspector dialog box such information from file properties on save '' Hit OK that says remove... Protect this information, make sure that any shared documents can contain that... Have rows, columns, and then click Inspect to identify hidden content your! With google for that purpose of some object types: Macro or VBA items that might the! Also deletes all reports and dashboard tiles that contain the data that 's with., Document Inspector will remove personal information from your Document, click the data... Cause of the document inspector can remove personal data from a workbook or hidden data and personal information the file tab, pick Info: revision tracking data upgrading! Only versions and annotations / functions for Excel 2019, as a shared workbook you can remove metadata from Document! That can not detect objects that are read-only a watermark to your.... See screenshot:, make sure you have the latest version of Office: in can... Mouse Hover in SharePoint 2010 use the Document Inspector might cause cached or hidden data personal. Only versions and annotations with other people text, you can remove personal data from external sources in. Comment is marked with a green triangle inspection in the Document Inspector dialog box, the. Include Document properties, comments, headers and footers workbooks can have scenarios that were defined by the!