File Sharing Problems

How to Create an External Link to One Excel Worksheet

Amos Gikunda Sep 28, 2026 869 views

Question details

The user wants to generate a web link to share or open only one specific worksheet from a larger Excel workbook as an independent file.

How to Share or Link to a Single Excel Worksheet

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing specific sheet data with external users or colleagues without exposing the entire workbook's contents.
Observed behavior: Excel does not natively support creating a web link for a single worksheet; sharing a link provides access to the entire workbook file.

Before you start

Before starting, ensure both your original workbook and the new destination file are saved in a secure location, such as OneDrive or a local shared drive, so external links can update correctly.

Solution 1Recommended

Extract and Link Data using a Separate Workbook

Since you cannot share a single sheet directly, create a new workbook and link it to the original data using external cell references.

This is the most straightforward workaround. By creating a dedicated workbook for the external user, you restrict access to the underlying data in the master file while ensuring the shared sheet stays updated.

Create a new workbook

Open Excel and press Ctrl+N to create a blank workbook. Save this file with a clear name, such as 'Shared_Sheet.xlsx'.

Reference the original data

In cell A1 of the new workbook, type an equals sign (=), then navigate to your original workbook, select the corresponding data range on the target sheet, and press Enter. The formula will look similar to =[OriginalFile.xlsx]SheetName!A1.

Copy the formula

Drag the fill handle across and down to cover all the rows and columns you need to share.

Share the new file

Upload the 'Shared_Sheet.xlsx' to your cloud storage (like OneDrive or SharePoint) and generate a sharing link for the recipient.

Data Updating: The recipient may see an 'Enable Content' or 'Update Links' prompt when opening the file. They must click it to pull the latest data from the source file.

Solution 2

Use Power Query for Complex Data Sharing

If your data requires cleaning or involves large tables, Power Query provides a robust way to pull specific sheet data into a new shared file.

Share Worksheets Easily

Easily Split and Share Single Worksheets in WPS Office

WPS Spreadsheet includes a highly efficient 'Split Workbook' tool. Instead of manually creating formulas or setting up Power Query connections, you can instantly save individual worksheets as independent files and generate secure sharing links directly from the WPS interface.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing the worksheet you want to share.
2. Use the Split Workbook tool: Navigate to the 'Data' tab on the top ribbon and click on 'Split Workbook'.
3. Select the target worksheet: Choose to split by worksheet, select the specific sheet you need to extract, and click 'Split' to generate an independent file.
4. Generate a sharing link: Open the newly created file, click the 'Share' button in the top right corner, and copy the web link to send to your external users.

One-click workbook splitting into separate files100% compatible with Microsoft Excel (.xlsx) formatsFree built-in cloud sharing to generate links instantlyLightweight and fast data processing

microsoft office alternative - wps office

Frequently Asked Questions

Can I just hide the other sheets instead of creating a new file?

Yes, you can hide the other sheets and protect the workbook structure with a password (Review > Protect Workbook). However, this is not fully secure; advanced users might still find ways to uncover the hidden data. Creating a separate file is the safest method for external sharing.

Will external reference links update automatically if the original file changes?

Yes, as long as both files are stored in a location accessible to Excel. When the recipient opens the linked file, Excel will typically ask if they want to update external links to reflect any recent changes made to the source data.

Can I save a single worksheet as a PDF to share a link?

Yes. If the recipient only needs to view the data and not edit it, you can navigate to File > Save As (or Export), choose PDF, and ensure 'Active Sheet' is selected in the options. You can then upload and share the PDF file.

Document & File Issues