Share via

How can I protect shared Excel file from copying the contents

Anonymous
2023-01-20T10:52:45+00:00

I need to know how I can protect Excel file to prevent users from copying the contents.

Can I achieve this using DLP policy? or which other possible ways can I use?

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-20T12:38:12+00:00

    Dear respected Sir D,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    As per your description, I'm sorry and I'm afraid to say that there is no DLP policy to achieve your requirement. But you may protect shared Excel file from copying the contents using protect sheet feature. Protect sheet will let user read contents but cannot select and copying.

    Here are the steps:

    1.Open your Excel file in Excel desktop client app and select the data cell and right-click on cell formatting>select protection tab>check/tick the "Locked" column.

    2.Click on Review tab>protect sheet>under protect sheet dialog box only check/tick the "Selected unlocked cells" option and user password to protect the Excel sheet.

    3.Then share file to users.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    4 people found this answer helpful.
    0 comments