Permission & Access Issues

How to Restrict Sharing and Forwarding of an Excel Workbook

Maira MehtabMaira Mehtab Nov 10, 2026 868 views

Question details

The user needs to know how to limit access to a shared Excel workbook and prevent unauthorized users from resharing or forwarding the document.

How to Restrict Sharing and Forwarding of an Excel Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
Sharing a sensitive Excel workbook and needing strict control over who can view, edit, or forward the file to others.
Observed behavior
Standard sharing links allow anyone with the link to access or forward the file. The goal is to restrict access exclusively to designated users and prevent unauthorized resharing.
Before you start

Ensure your Excel workbook is saved to a cloud location like OneDrive or SharePoint, as advanced sharing and tracking features require cloud storage to function properly.

Solution 1Recommended

Use the 'Specific People' Sharing Option

Restrict access by sending the workbook only to named individuals, preventing unauthorized users from opening forwarded links.

By default, sharing links might be set to 'Anyone with the link' or 'People in your organization'. Changing this to 'Specific people' ensures that even if the link is forwarded, the recipient cannot open the workbook unless their email address was explicitly authorized by you.

1
Open the Share menu

Click the 'Share' button located in the top right corner of the Excel application or Excel for the Web.

2
Modify link settings

In the sharing dialog box, click on the current link settings (for example, 'Anyone with the link can edit') to open the permissions menu.

3
Select Specific people

Choose the 'Specific people' option from the list. You can also uncheck 'Allow editing' if you only want the users to view the data.

4
Apply and send

Click 'Apply', then enter the exact email addresses of the users you want to grant access to. Click 'Send' to share the secure link.

Use the 'Specific People' Sharing Option
Managing Access Requests: If an authorized user forwards the link to someone else, the new recipient will receive an error when trying to open it. They will be prompted to request access, giving you the final decision to approve or deny.
Free Microsoft Office alternative

Secure Your Spreadsheets Easily with WPS Office

If you are looking for a cost-effective and straightforward way to manage and protect your spreadsheets without complex enterprise configurations, WPS Office is a powerful, free alternative to Microsoft Office. It offers robust password encryption and seamless compatibility with Excel files, ensuring your sensitive data remains secure.

  1. 1. Open the file: Open your spreadsheet in WPS Office.
  2. 2. Access encryption settings: Go to the 'Menu' and select 'Document Encryption'.
  3. 3. Set passwords: Set a password for opening or modifying the document, then save the file.
Fully compatible with Microsoft Excel (.xlsx, .xls) formats.Built-in document encryption and password protection to restrict unauthorized access.Lightweight and free to use with a familiar, easy-to-navigate interface.Easy cloud sharing with customizable permission settings.
microsoft office alternative - wps office

Frequently Asked Questions

Can I completely prevent someone from copying data from my shared Excel workbook?

No sharing setting can completely prevent an authorized user from copying information. Even with restricted permissions, a user who can view the file might take screenshots, take photos with a phone, or manually transcribe the data. It is best to apply appropriate information-protection policies and only share sensitive data with trusted individuals.

How do I know if someone has forwarded my Excel sharing link?

If you use the 'Specific people' sharing option, unauthorized users who receive a forwarded link will not be able to open it. They will be prompted to request access. When they do, you will receive an email notification for the access request, effectively alerting you that the link was forwarded.

What are Microsoft Purview sensitivity labels?

Microsoft Purview sensitivity labels are an enterprise-level security feature in Microsoft 365. They allow organizations to classify and protect documents by applying encryption, access restrictions, and visual markings (like watermarks) based on the confidentiality of the content.

Can I check who has accessed my shared Excel workbook?

Yes, if your workbook is stored on OneDrive for Business or SharePoint, you can view the file's version history and activity. For a more comprehensive audit, your Microsoft 365 administrator can review activity logs to see exactly who has accessed, modified, or shared the file.