How to Link Excel to OneNote

Your meeting notes live in OneNote and the numbers live in an Excel workbook, and you want them on the same page. In the OneNote desktop app, go to Insert > Spreadsheet > Existing Excel Spreadsheet and pick Attach File, Insert Spreadsheet or Insert Chart or Table. Each of those adds a copy. If you need the live workbook, insert a link to it with Insert > Link instead.

Link, Embed or Attach: Pick the One You Actually Need

People say “link Excel to OneNote” for three different jobs, and OneNote handles each one differently. The most important fact to know up front: anything you put on the page through the Spreadsheet button is a copy. Microsoft’s Add an Excel spreadsheet to a page article says changes you make to the spreadsheet in OneNote won’t appear in the original Excel file, and changing the original won’t update the copy in OneNote.

What you want	Use this	Stays in sync with the original?
Keep a copy of the workbook with your notes, as a file icon	Insert > Spreadsheet > Existing Excel Spreadsheet > Attach File	No
See the whole sheet on the page as a table	Existing Excel Spreadsheet > Insert Spreadsheet	No (static)
Show only one table or chart from the workbook	Existing Excel Spreadsheet > Insert Chart or Table	No (static)
Build a small new sheet right inside the notes	Insert > Spreadsheet > New Excel Spreadsheet	It is its own file, with no original to sync
Open the real, current workbook from the page	Insert > Link (Ctrl+K) to the file	Yes, because it opens the actual file

A quick way to decide: if the numbers will keep changing after the meeting, use a link. If you want a snapshot of what the numbers looked like on the day you took the notes, use an embedded copy. Plenty of people do both, a static table for context and a link underneath it for the current version.

Which OneNote App You Need

The Insert > Spreadsheet commands are documented for the OneNote desktop app on Windows: Microsoft lists OneNote for Microsoft 365, OneNote 2024, OneNote 2021 and OneNote 2016 as the versions the article applies to. Opening or editing an inserted spreadsheet launches Excel, so you need Excel on the same computer to work with it.

If you used the older OneNote for Windows 10 app, it is no longer the one to use. According to Microsoft’s Moving to OneNote on Windows page, OneNote for Windows 10 reached end of support on October 14, 2025 and became read-only, and the replacement is the OneNote on Windows app from the Microsoft Store. To check which one you have, look for a File menu at the top of the window. If you see File, you are on the current app.

OneNote for the web, OneNote for Mac and the phone apps are not listed on Microsoft’s spreadsheet article, so don’t expect the same Spreadsheet button there. Links (covered below) are the more portable option if you move between devices.

Insert an Existing Excel Workbook Into a OneNote Page

Here is the walkthrough with a worked example. Delphine runs a weekly budget meeting and keeps her notes in a notebook called Team Budget. The numbers are in a workbook named Q3-Budget.xlsx with a summary sheet and a chart of spending by department.

1. Save and close the workbook in Excel if you have been editing it, so OneNote picks up the latest saved version.
2. In OneNote, open the page for this week’s meeting and click the spot on the page where the spreadsheet should go.
3. Select the Insert tab, then select Spreadsheet.
4. Choose Existing Excel Spreadsheet.
5. Browse to the workbook (Q3-Budget.xlsx in the example), select it and select Insert.
6. Pick one of the three options OneNote offers: Attach File, Insert Spreadsheet or Insert Chart or Table.

What each option gives you:

• Attach File places an Excel icon on the page. Double-click it to open the attached copy in Excel. This is the best choice when the workbook is large or has many sheets, because it keeps the page tidy.
• Insert Spreadsheet puts the entire spreadsheet on the page as a static table. Readers can see the numbers without opening anything.
• Insert Chart or Table lets you choose specific tables or charts from the workbook. Delphine would use this to drop only the department spending chart onto her page instead of every row of the summary sheet.

Remember that all three are copies. If someone updates Q3-Budget.xlsx on Thursday, the table on Monday’s page still shows Monday’s numbers. That is often exactly what you want in meeting notes, but write the date next to the table so nobody mistakes it for the current figures.

If you only need a particular sheet, it can be easier to save that sheet as its own file first. Here’s how to save a single worksheet from Excel as a separate file, which you can then attach or insert.

Create a New Excel Spreadsheet Inside OneNote

When the numbers don’t exist yet, you can start a sheet from the page itself. This works well for a quick tally, such as action items with cost estimates.

1. Click where you want the spreadsheet on the OneNote page.
2. Select Insert > Spreadsheet > New Excel Spreadsheet.
3. OneNote adds an Excel icon and a blank preview image to the page.
4. To fill it in, double-click the Excel icon. The sheet opens in Excel as a fully working spreadsheet.
5. Enter your data, then save and close it in Excel. The preview on the OneNote page updates to show what you entered.

Warning before you tidy up the page: don’t delete the Excel icon. Microsoft notes that if you delete the icon, you won’t be able to edit the spreadsheet anymore. The preview image can stay on the page, but it becomes just a picture of the data.

The preview is an image, so you can’t click into its cells and type. All editing happens in Excel after you open it from the icon.

Link to the Live Workbook From a OneNote Page

A link is the only route that always opens the current version, because nothing is copied. Clicking the link opens the real workbook in Excel (or in Excel for the web if it lives in the cloud), so anyone with access sees today’s numbers.

Link to a File on Your Computer or Network

1. Type the words you want people to click, such as “Current Q3 budget”, and select them.
2. Choose Insert > Link, or press Ctrl+K.
3. The selected words appear in the Text to display box.
4. In the Address box, use the button to locate a file and select the workbook, or type its path.
5. Select OK. The text turns into a clickable link.

Microsoft’s Create or edit a link in OneNote article covers this dialog and shows that a file path link works too. The catch with a file on your own drive: it only opens on your computer. A link to C:\Users\… on Delphine’s laptop does nothing for a teammate reading the same notebook.

Link to a Workbook in OneDrive or SharePoint

For a shared notebook, keep the workbook in OneDrive or SharePoint and link to its web address instead.

1. Open the workbook in Excel and use Share to copy a link to it (or copy the address from the browser if you have it open in Excel for the web).
2. Back in OneNote, select your link text and press Ctrl+K.
3. Paste the address into the Address box and select OK.

You can also paste the address straight onto the page. OneNote usually recognizes a typed or pasted web address and turns it into a link on its own. Check the sharing settings on the workbook: a link only helps teammates who have permission to open the file. If several people will edit the workbook at once, see how to let multiple users work in the same Excel file.

Link From Excel Back to a OneNote Page

Sometimes the link needs to go the other way: a row in your tracker should open the meeting notes where that item was discussed. OneNote can copy a link to any page, and Excel can turn that link into a clickable cell.

1. In OneNote, right-click the page’s tab in the page list and choose Copy Link to Page.
2. In Excel, click the cell where the link should go.
3. Paste the link with Ctrl+V. It usually pastes as a clickable link; if it pastes as plain text, use the HYPERLINK function in the next step.
4. For a tidier label, use the HYPERLINK function instead, for example =HYPERLINK("paste-the-link-here","Sept 8 budget notes"), putting the copied link inside the first pair of quotation marks.

Microsoft’s HYPERLINK function page explains the two parts: link_location (the address) and an optional friendly_name, which is the text shown in the cell as a link. It also notes that Excel for the web only accepts web addresses in this function, which is fine for links to notebooks stored in OneDrive.

Need to point at one exact spot on a long page? Hover at the left edge of a paragraph, right-click the four-headed arrow that appears and choose Copy Link to Paragraph. Both commands are described on Microsoft’s page about creating links to notebooks, sections, pages and paragraphs.

Can You Link a Single Cell or Range?

Not as a live value. Microsoft doesn’t document any way to show one Excel cell or range on a OneNote page that updates when the workbook changes. Copying cells and pasting them onto a page gives you a copy, just like the Insert commands.

Workable alternatives:

• Use Insert Chart or Table to bring in just the part you care about, then insert a fresh copy whenever you need updated figures. Formatting the range as an Excel table first makes it easy to pick.
• Keep the key number on a small summary sheet and link to the workbook, so the current value is one click away.
• If the source data needs to refresh on its own inside Excel, set that up in the workbook. There’s a separate walkthrough on making an Excel spreadsheet update automatically; OneNote’s copy still won’t follow those changes.

The reverse also exists in a limited form: if you built a table in OneNote and want it in Excel, click inside the table, open the table tab (Microsoft calls it Table Tools) and choose Convert to Excel Spreadsheet. Microsoft documents this on its Convert a OneNote table to an Excel worksheet page.

When It Doesn’t Update or Won’t Open

The Table on the Page Shows Old Numbers

That is expected for any inserted spreadsheet, chart or attachment. Delete the old copy and insert the workbook again, or replace the copy with a link to the file. If you edited the attached copy from OneNote, your edits are saved in the notebook, not in the original workbook, so copy them back to the original by hand if they matter. Some versions show extra options when you right-click an inserted spreadsheet, but Microsoft describes inserted tables and charts as static copies, so don’t count on them to pull in changes from the original workbook.

There Is No Spreadsheet Button

Check that you’re in the desktop OneNote app (look for the File menu) and not OneNote for the web, Mac or OneNote for Windows 10. If the button is there but nothing opens, check that Excel is installed on that computer.

You Can’t Edit the New Spreadsheet Anymore

If the Excel icon was deleted, the editable file went with it. Press Ctrl+Z right away to undo the deletion. If that’s no longer possible, check the notebook’s history or backups. This is a good reason to keep regular copies; see how to back up your OneNote notebooks.

A Link Opens for You but Not for Teammates

The link probably points to a file on your own drive, or the shared file’s permissions don’t include them. Move the workbook to OneDrive or SharePoint, share it with the right people and link to its web address. A file link also breaks if the workbook is moved or renamed, so update the link after reorganizing folders.

The Page Is Slow or Prints Badly

Inserting a very large sheet as a table can make the page slow to scroll and sync. Use Insert Chart or Table to bring in only the range you need, or attach the file as an icon. When printing or exporting the page, check the result, since a wide sheet may not fit the way it looks on screen.

When Excel and OneNote Don’t Cooperate

Is There a Paste Option That Keeps Pasted Cells Linked to Excel?

Microsoft doesn’t document one for OneNote. Pasted cells behave like the other copies, so treat a paste as a snapshot and add a link to the workbook if readers need current figures.

Does an Attached Workbook Make My Notebook Bigger?

Yes. An attached or inserted file is stored in the notebook, so it adds to the notebook’s size and syncs with it. A link adds almost nothing, which is another point in its favor for large workbooks.

Can People Without Excel See the Inserted Table?

The static table or chart is part of the page, so they can read it. Opening or editing the spreadsheet behind an icon needs Excel.

Should I Use the Same Approach for Word Documents?

The same thinking applies: attachments and printouts are copies, links open the real file. If you’re moving Excel data into Word rather than OneNote, mail merge is the better tool; this walkthrough on merging Excel data into Word documents shows how.

Where to Start

Open a OneNote page and try both on a test workbook: insert it with Insert Chart or Table, then add a Ctrl+K link underneath. Change a number in the workbook and you’ll see the difference right away, which makes it easy to pick the right one for your real notes.