How to Share and Synchronize an Excel File in OneNote
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.

- 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.
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.
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.
Open your OneNote desktop application. Navigate to the 'Insert' tab on the ribbon, click on 'Spreadsheet', and select 'Existing Excel Spreadsheet'.
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.
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.

Share and Restrict Permissions via Microsoft Teams
Use this method if you need strict control over who can edit the file, as Teams allows granular file permission settings.
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. Open Your Spreadsheet: Launch WPS Spreadsheet and open the workbook you want to collaborate on.
- 2. Click Share: Click the 'Share' button located in the top right corner of the application interface.
- 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.

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.




