File Sharing Problems

How to Share Only One Worksheet from an Excel Workbook

Khadija Khan Sep 28, 2026 869 views

Question details

The user wants to know if it is possible to securely share only a single worksheet from an Excel workbook without granting the recipient access to the rest of the file.

How to Share Only One Worksheet from an Excel Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing specific data with external or internal users while keeping other worksheets in the same file private.
Observed behavior: Excel's default link-sharing feature directs users to a specific sheet but still grants them access to the entire workbook, failing to restrict viewing to just one worksheet securely.

Before you start

Before proceeding, determine whether the recipient only needs to view the data or if they require editing rights, as this will dictate the most secure and appropriate sharing method.

Solution 1Recommended

Copy the Worksheet to a Separate Workbook

The most secure and reliable way to share only one worksheet and entirely prevent access to the rest of the original workbook.

Because Excel does not have a native feature to securely restrict a shared cloud link to a single worksheet, physically separating the data is the best approach for privacy.

Open the Move or Copy dialog

Right-click the worksheet tab you want to share at the bottom of the Excel window and select 'Move or Copy'.

Create a new workbook

In the 'To book' dropdown menu, select '(new book)'. Ensure you check the 'Create a copy' box so your original workbook remains intact.

Save and share the new file

Click OK to generate the new workbook. Save this new file to your computer or cloud storage, and share it with your recipients.

Copy the Worksheet to a Separate Workbook

Solution 2

Embed a Specific Worksheet Range for View-Only Access

A practical workaround to display only a selected range or sheet to viewers via a web link without giving them the actual file.

Solution 3

Use the Direct Link Feature (Non-Secure)

Directs users immediately to a specific part of the workbook, though they can still access and view other sheets if they choose.

Share Sheets Easily

Manage and Share Specific Worksheets Securely with WPS Office

WPS Spreadsheets provides a highly compatible and user-friendly interface for managing, extracting, and sharing single worksheets without compromising the security of your entire workbook.

1. Open your workbook: Launch WPS Spreadsheets and open the workbook containing the sheet you want to share.
2. Extract the worksheet: Right-click the worksheet tab you want to share and select 'Move or Copy'. Choose 'New Book', check 'Create a copy', and click OK.
3. Save and share securely: Save the newly created workbook containing only the single sheet, and share the file securely via email or cloud link.

Easily extract and save single sheets as new files in just a few clicksSeamless compatibility with Microsoft Excel (.xlsx) formatsLightweight, fast, and completely free to useBuilt-in robust sharing, password protection, and permission settings

microsoft office alternative - wps office

Frequently Asked Questions

Does the 'Copy link to sheet' feature hide other tabs?

No. While the link directs the user to the specific sheet, range, or chart you selected, it still grants them access to the entire workbook. They can easily click on other tabs at the bottom to view the rest of your data.

How can I share a single worksheet as a non-editable file?

You can save the single worksheet as a PDF. Navigate to File > Save As, select PDF from the format dropdown, and under the save options, ensure you are exporting only the 'Active sheet' before sharing the document.

Can I use password protection to hide other sheets instead of moving them?

Yes, you can manually hide the sheets you do not want seen, and then protect the workbook structure with a password by going to Review > Protect Workbook. This prevents users from unhiding the sheets, though extracting the single sheet to an entirely new file is generally considered more foolproof and secure.

Document & File Issues