File Sharing Problems

How to Sync One Excel Worksheet to SharePoint Online

Amos Gikunda Sep 27, 2026 868 views

Question details

Users want to synchronize a single worksheet from a local Excel master workbook to a SharePoint Online folder without sharing the rest of the workbook data.

How to Sync One Excel Worksheet to SharePoint Online

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing specific worksheet data to a SharePoint folder while keeping the rest of the master workbook private and unshared.
Observed behavior: Excel and SharePoint do not offer a built-in feature to sync just one worksheet; sharing a file to SharePoint uploads the entire workbook by default.

Before you start

Ensure you have editing access to the target SharePoint Online folder. Since Excel lacks a one-click feature to sync a single worksheet, you will need to utilize external cell references (linked workbooks) or create an automated workflow.

Solution 1Recommended

Use a Linked Workbook in SharePoint

Create a separate, linked workbook in SharePoint that dynamically pulls data from your master file, keeping the rest of the master file private.

This is the most straightforward workaround. By creating a new workbook in SharePoint and linking its cells to your master workbook, the SharePoint file acts as a mirror for that specific worksheet. Users with access to the SharePoint folder will only see the linked data.

Create the destination workbook

Navigate to your SharePoint Online folder and create a new, blank Excel workbook. Open it in the Excel desktop application.

Open the master workbook

Open your local master workbook (which contains the worksheet you want to sync) in the Excel desktop application alongside the new SharePoint workbook.

Link the data cells

In the new SharePoint workbook, select cell A1, type '=', then switch to your master workbook. Select the data range you want to sync, and press Enter to create an external reference link.

Save and manage links

Format the new workbook as needed and save it. Whenever the master workbook is updated, the data in the SharePoint workbook will refresh when opened or when links are manually updated.

Data Privacy Maintained: SharePoint users will only be able to view the data pulled into the new workbook. Your local master workbook and its other sheets remain completely hidden from them.

Solution 2

Automate Data Sync using Power Automate

Set up a flow in Microsoft Power Automate to automatically copy and update rows from your local worksheet to a separate SharePoint file.

Free Microsoft Office alternative

Experience Seamless File Management with WPS Office

While synchronizing specific worksheets to SharePoint requires complex workarounds in Microsoft Excel, WPS Office provides an excellent, lightweight alternative for managing and extracting your spreadsheets. Enjoy built-in cloud integration, advanced data extraction tools, and full compatibility with Microsoft formats for free.

1. Download and Install: Download WPS Office for free from the official website and install it on your computer.
2. Open Your Master File: Launch WPS Spreadsheets and open your existing master Excel (.xlsx) workbook.
3. Extract and Share: Right-click the worksheet tab you want to share, select 'Move or Copy', and check 'Create a copy' to a 'New Book'. Save this new book to WPS Cloud and share it securely via a customizable link.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats.Easily split, extract, and share specific worksheets with built-in tools.Securely share specific files using WPS Cloud collaboration features.Lightweight software that opens files quickly and runs smoothly.

microsoft office alternative - wps office

Frequently Asked Questions

Can I share a single Excel sheet without sharing the whole workbook in Microsoft 365?

Not directly through standard sharing buttons. By default, granting someone access to an Excel file gives them access to the entire workbook. You must extract the specific sheet into a new file or use external linked workbooks to share only specific data.

Does Power Automate require a premium license to sync Excel to SharePoint?

The standard Excel Online and SharePoint connectors used for basic row synchronization are included in most standard Microsoft 365 business plans. However, processing exceptionally large datasets or using advanced database connectors may require a premium license.

Will linking cells between two workbooks slow down my Excel file?

Having extensive external links can impact file performance. If you link tens of thousands of cells between your master workbook and the SharePoint destination file, the file may take longer to open and calculate. In such cases, Power Automate might be a more stable long-term solution.

Can I hide sheets and password protect the master workbook instead?

Yes, you can hide the sensitive sheets in your master workbook and protect the workbook structure with a password before uploading it to SharePoint. However, this is not perfectly secure, as users with access to the file could potentially use third-party tools to bypass structural protection.

Document & File Issues