Remove Metadata From Excel 2016

Remove Metadata From Excel 2016
Remove Metadata From Excel 2016 File
Remove Metadata From Excel 2016 Online

Excel saves a lot of meta data in your Workbooks by default. Even personal information (like your name!) is stored, which may not always be desirable.

Remove metadata from Office files, PDFs, and images. Make sure you're not communicating more than you intend to when sharing files and uploading images by excising some of the data about your data. All your documents have hidden metadata. Do not share more information than you would like. By a simple click remove all metadata in your document. Wipe metadata for free Please, select the document from your device Allowed extensions: '; Drop files here to upload.Maximum size of the file is 30 MB. All communication with the server is secured. Remove From My Forums. To-sharepoint-library-including-metadata Question 9 4/21/2016 1:09:11 PM 4/26/2016 7. With open xml SDK read the excel metadata and set. Figure 4: You can remove metadata from your documents. When the inspection completes, Word shows you the information that you asked for and gives you the option of removing unwanted properties, as.

The best way to remove your name and other info from a workbook is not from within Excel, but from its containing folder in Windows:

Start by right-clicking the Excel file, then click Properties…

In the Properties pane, click the Details tab, then Remove Properties and Personal Information…

Next, in the Remove Properties pane, click Remove the following properties from this file, uncheck the box next to Authors and Last saved by (and any other info you want), and click OK…

The items you selected are now removed from the file. That is, until you open the file again! Unfortunately, you’ll have to do this each time you open and close the file, as there is no way to prevent the automatic storing of this information.

Additionally, and annoyingly, Excel (and other software) does not allow removal of certain meta data like Date created, Date modified, and Date acessed (notice below, no check boxes next to these items). The Computer name, however, only looks like its being stored; this is actually just showing the computer currently viewing the file properties…

Avoid unintentionally distributing hidden information, such as the document's author, names that are associated with comments or tracked changes, or hidden cells or worksheets, by removing hidden data.

Use the Document Inspector to Remove Hidden Data

To open the Document Inspector, click File > Info > CheckforIssues > Inspect Document. The Excel Document Inspection window shown below opens up.

Click Inspect to identify hidden content, and then click Remove All to remove the item of your choice.

After you have completed these steps, save the document, and the spreadsheet will not contain the hidden data that you have removed.

Edit Document Properties, Personal Information and Other Document Data

To selectively edit or remove document data, click File > Info > Properties. ClickShow All Properties.Delete or edit information.

Selectively Remove or Edit Comments

Microsoft Excel offers the ability to add comments to workbooks. Typically, comments contain the name of the person who created them, and they appear as a small red triangle in the upper-right corner of a cell.

To view a comment, click the cell and the comment will pop up.

To delete a comment, right-click the cell containing the comment, and then click Delete Comment on the shortcut menu.

Selectively Display Hidden Cells, Rows, and Columns

In Microsoft Excel, it is possible to hide entire rows and columns of cells within a worksheet.

To unhide all of the cells in a worksheet:

Click the SelectAll button, in the upper-left corner of the worksheet or press Ctrl + A.
Click the Home tab > Format (in theCells group) > Hide & Unhide > Unhide Rows or Unhide Columns.
All cells are now visible.