Comments on: How to view, change and remove document properties in Excel

The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel. In this article you’ll also learn how to protect your document from any modifications and remove personal information from your Excel worksheet. Continue reading →

Table of contents

Comments page 2. Total comments: 38

  1. Really good tips. Thank you!!!

  2. Charles - if they are Office docs, you can select all the documents, then right click and choose properties. Make your updates then press Ok/Apply. The properties on all the selected documents will at once.

  3. Hi, Great article. It doesn't address a question I have: I'm faced with 119 similar documents. I'd like to change the title, subject and author in a batch so they all match. Two of these fields will match in every doc and I will individually change the others. Is there a way to do this and how to do it? I can do this and do it routinely in Adobe Acrobat Pro's Action Wizard to manage actions.

  4. Hello:

    Thank you for your excellent article.

    Q: Is it possible to change the created date and time in properties?

  5. Is there a way to fill in the Title based on a field using Visual Basic or any other method?

  6. I found this post very helpful! I further wanted to know whether the author who modify the document last can be changed or not?
    I thank you

  7. Can anyone solve the following: By default, every word document I create has the metadata TAG "XYZ" associated with it by default, probably by the last user of my networked computer in my office. How do I remove this default? I did read the great article here, and while I know how to change the AUTHOR default, how do I change other defaults (TAGS, COMMENTS, STATUS) in every document created forthwith? Thanks.

  8. The information and presentation is very useful.

    Is there any way to lock the properties such as "Author" of the document, while the editing is allowed? Thanks.

  9. alprazolam 0 5mg ems ms - xanax for anxiety and stress

  10. Ekaterina,

    Do you know how to hide Protected sheet's names?

    I can hide a protected sheet name with xlVeryHidden. But it is still visible in the backstage under permissions. Is it possible to hide sheet name from here also?

    Thanks

  11. what if we have a user that when he clicks on remove properties and personal information for office documents nothing will pop up?

  12. If you want to let some people modify the worksheet after all, you can set a password for those who want to change something in the document.

  13. I came across this useful article, but I am not sure what the advantage is for using this document property function in excel. Can someone explain the benefit from it ?

  14. Excellent post. Would you know how I could sync the document properties on the server with the custom properties tied to the SharePoint site columns?

    thanks.

  15. I love the details in this post. Thank you very much!

  16. This is a very useful post
    it really helped me a lot.
    Thank you very much.
    keep the good work.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)