Thursday, October 4, 2018

microsoft office - How to change or remove all traces of original author name in Excel 2010 document


At our company we need to deploy one Excel Workbook in that way that nobody would see it is made by us by looking at the Office metadata.


What fields do we need to look for? I know, that the document has track of original writer and the last save author. But is it all? I guess there might be some hidden properties, that might give our company name.


Where to look for such fields? Is there any good editor available, or will explorer's property page give enough power?


I use Excel 2010


Answer



In Office 2010, like some earlier versions, there is an option to "Prepare for Sharing".


First go to the "File" tab, then select "Info".


enter image description here


In the right hand pane you'll see "Prepare for Sharing", which may already show some issues:


enter image description here


Click "Check for Issues" -> "Inspect Document", which will pop up a window, where you can select the issues you want to look at:


enter image description here


From what you've said, the most important one to check is "Document Properties and Personal Information", but I'd leave them all selected, personally. When you're happy, click 'Inspect', which will produce a report:


enter image description here


Now just click on "Remove All" as needed in each category to remove any of the information that has been returned (in this case 'Author').


Then save the file (presumably with a new name if you want to retain the metadata in your original for internal use).


No comments:

Post a Comment

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...