We all know that you can insert a live view of your spreadsheet on OneNote 2016. On the Windows 10 version however, the button to do so has been taken away and most of us simply insert file to attach our Excel spreadsheet. What if I tell you that there is a workaround for this? :)
In this article, I'm going to share with you how you can add your live spreadsheet to OneNote and allow it to sync every time you make changes to your Excel file.
What You Need:
OneNote Windows 10
OneDrive (web version)
Excel spreadsheet
Yes, just these three things and you're ready to go!
Step 1: Upload or Create Your Excel Sheet in OneDrive
OneDrive offers 5GB of free storage for your files, and you can create a workbook by going under New > Excel Workbook, or upload a spreadsheet by clicking on Upload > File.
Step 2: Open Up Your Excel File in the Browser
By double clicking on the file you uploaded/created, it will open up the excel workbook in the browser that you are working on.
Step 3: Copy the Web Link of Your Excel Workbook & Paste into OneNote
Probably the simplest and most magical step. Copy the link of your spreadsheet in the browser, and paste it into whichever page you like. This automatically generates a live view of the excel spreadsheet. You can now sync changes in your file, adjust the spreadsheet size, and even use your filters directly in OneNote.
NOTE: The spreadsheet is VIEW ONLY. It cannot be edited directly from OneNote, however, you can simply click on the web link to edit in browser.
Follow for more OneNote tips & tricks! :)