File Sharing Problems

How to Share and Synchronize an Excel File in OneNote

Khadija KhanKhadija Khan Oct 21, 2026 872 views

Question details

The user wants to share, edit, and synchronize an Excel workbook using OneNote and Teams while maintaining strict control over who can modify and save the file.

How to Share and Synchronize an Excel File in OneNote
Product
Microsoft Excel and OneNote
Device & OS
Windows
Scenario
Collaborating on a spreadsheet embedded in a shared OneNote notebook or Teams channel, requiring specific user permissions.
Observed behavior
The user needs a method to ensure the embedded Excel file syncs correctly across the platform without allowing unauthorized edits to the original file.
Before you start

Ensure you are using the OneNote desktop application for Windows, as advanced Excel embedding and live synchronization features are fully supported on the desktop version rather than the web or mobile apps.

Solution 1Recommended

Embed and Sync the Excel Workbook in OneNote

Use this method to directly embed an Excel file into your OneNote notebook so that edits are synchronized when opened from OneNote.

When you attach a file as a static image, OneNote only captures a snapshot of the data, meaning subsequent changes will not synchronize. To keep your data synced, you must embed the actual spreadsheet and launch it from within the notebook.

1
Insert the Spreadsheet

Open your OneNote desktop application. Navigate to the 'Insert' tab on the ribbon, click on 'Spreadsheet', and select 'Existing Excel Spreadsheet'.

2
Select the Embed Option

Locate and select the Excel file you wish to share. When prompted, choose 'Insert Spreadsheet' to embed the live file rather than inserting a static printout.

3
Edit and Synchronize

To make changes, double-click the embedded 'Edit' button on the spreadsheet inside OneNote. This will open Excel. Make your changes and save the file; the updates will automatically reflect in your OneNote notebook.

Embed and Sync the Excel Workbook in OneNote
Permission Limitations in OneNote: OneNote notebook permissions apply to everything inside the notebook. If a user has edit access to the OneNote page, they can generally edit the embedded Excel file.
Free Microsoft Office alternative

Easily Share and Collaborate on Spreadsheets with WPS Office

If managing permissions across OneNote and Teams feels overly complex, WPS Office provides a lightweight, free alternative. With seamless Microsoft Excel format compatibility, you can effortlessly host spreadsheets in the cloud and generate customized sharing links with precise view or edit permissions.

  1. 1. Open Your Spreadsheet: Launch WPS Spreadsheet and open the workbook you want to collaborate on.
  2. 2. Click Share: Click the 'Share' button located in the top right corner of the application interface.
  3. 3. Set Permissions: Choose your desired permission level, such as 'Anyone with the link can view' or 'Specific people can edit', and distribute the link to your team.
Fully compatible with Microsoft Excel (.xlsx, .xls) formatsEasily share files via customizable, secure web linksSet specific view, edit, and download permissions for collaboratorsFree and lightweight alternative to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the static image of my Excel file synchronize in OneNote?

A static image inserted into OneNote is simply a visual snapshot of the spreadsheet at that exact moment. To ensure changes synchronize, you must embed the workbook as a live file and open it directly from OneNote to make edits.

Can I set read-only permissions for specific users on an Excel file in Teams?

Yes. When an Excel file is stored in Microsoft Teams, you can manage access by clicking the ellipsis next to the file, selecting 'Manage Access', and changing specific team members' or groups' permissions from 'Can edit' to 'Can view'.

Is the Excel embedding feature available on all versions of OneNote?

Fully embedding and synchronizing live Excel spreadsheets is primarily supported in the OneNote desktop application for Windows. Web and mobile versions typically only allow you to view the attached file as a standard document.

What happens if my Excel file is stored on a local work network server?

If you link or embed a file stored strictly on a local network server, other users will only be able to open and sync the file if they are actively connected to that same local network or VPN.