To remove document metadata follow these four steps. This feature works the same in all modern versions of Microsoft Word: 2010, 2013, and 2016. Select the File menu tab and then select Info, if necessary. Select Check for Issues and then select Inspect Document. In the Document Inspector dialog box, check the boxes to inspect for certain data. This is a picture I took. With my camera, from the stone ages, like all of my tech. I can tell you the exact date and time: 5:22 PM; I can tell you the exact size: 4320×3240 (4.43 MB) I can tell you the make of camera: SONY DSC-W330.
Not only metadata, but anything possible confidential is found and can be removed with just a few clicks. Open your Excel file in Excel and click on “File” in the top-left corner of the window. Alternatively press Alt and then F on the keyboard. Click on “Info” on the left-hand side.
Recently, I’ve been given a task to remove personal info via scripting, for a set of documents, which consisted of Word, Excel, and PowerPoint documents, both old, and new format (doc, docx, xls, xlsx, etc.)
Remove Metadata From Excel 2016 File
Testing revealed, that RemoveDocumentInformation has a lot of limitations.
It the below script, I tried to catch most of the errors, but still, exceptions occur.
I hope it will help someone, who is tasked to do such thing.
Script requires Office applications to be available on the host.
It will ask for source directory, it is also used for storing the log files.
After script completion, you will see summary screen, showing total processed documents and log file locations. All documents that script is unable to process for some reason, goes to error log.
Remove Metadata From Excel 2016 Online
Script removes all modification protection and personal information from documetnts in source directory, except documents with password to open (encrypted), and excel files with worksheets locked for editing.
“password to modify” and “suggested read only” are removed from all documents along with personal information.