Great productivity video. I have not used both OneNote and Excel together and it looks like a great way for a team to use Teams with OneNote with Excel docs integrated. Time for me to test and practice!
Yes, either option is a copy of the file, that was not noted in the second option shown but you can see that in the file name with is Sales_Orders14. Due this local copy and editing of the file in OneNote, it is not updating the original file, if you open the original file, it will not have the updates you see in OneNote. Makes it almost, if not impossible, to use this workflow across computers and devices.
Hey thanks Andy for this. When embedding the Excel spreadsheet is there an option to make updates from WITHIN One note, or will it always open up the Excel spreadsheet when editing from within One Note? Thanks!
Thanks for this Andy. Unfortunately there's an issue in this respect in terms of cross-device usage for the same excel spreadsheet. From briefly playing with this, as a temp file will be saved on your computer you can't access that same file from as smoothly from the OneNote section on another device (e.g. mobile or tablet). Is there any way to insert the spreadsheet, and when opening it from OneNote, have it open the master/original document - this would easily resolve the issue when accessing/viewing/editing the spreadsheet from multiple devices.
Hi Andy, Is there a way to choose what cells are shown in the embedded image of the spreadsheet within OneNote? It automatically shows the 7 or so columns and maybe the first 100 rows. What if I want the embedded image to only show 3 columns and 15 rows? Or 20 columns and 3 rows? When clicking "Select what to display" it only allows you to choose different sheets. Hoping there's a way to choose what is displayed in the embedded image... Is the only workaround creating a table out of the data and selecting the table as what is displayed? What if you don't want the whole table displayed in the embedded image?
I have an embedded spreadsheet in OneNote. Some of the cells have hyperlinks. They do not fire in the embedded copy, but they do in the Excel file. Is there any way to make this work? It appears to be view only.
@@AndyPark365 thanks for your reply I actually have a question for you regarding one note as when I make a sub group and open it in the mobile application you can't squeeze this subgroups and it's keep all the time open
🛑🛑🛑🛑 WARNING 🛑🛑🛑🛑🛑 First thing you should do is warn them that vba code WILL NOT RUN if the spreadsheet is run from onenote. I have been working for days changing security and macro settings and the code will not run. 🛑🛑🛑🛑
Thanks, Andy. You took the mystery out of the options clearly and succinctly. Owe you one.
Very clear and concise explanation. Well done and thanks for sharing👍🏾
Excellent explanations. This was very helpful. Thank you for making this video.
Great productivity video. I have not used both OneNote and Excel together and it looks like a great way for a team to use Teams with OneNote with Excel docs integrated. Time for me to test and practice!
Thanks Andy!! Great tip
This was very helpful. Thank you!
I didnt realize this, thank you!!!
Hi Andy, thanks for you video. Do you know if there is a way to update and modify the original Excel file instead of the copy of it? thanks
Yes, either option is a copy of the file, that was not noted in the second option shown but you can see that in the file name with is Sales_Orders14. Due this local copy and editing of the file in OneNote, it is not updating the original file, if you open the original file, it will not have the updates you see in OneNote. Makes it almost, if not impossible, to use this workflow across computers and devices.
Hey thanks Andy for this. When embedding the Excel spreadsheet is there an option to make updates from WITHIN One note, or will it always open up the Excel spreadsheet when editing from within One Note? Thanks!
bonjour, est il possible de modifier la zonne du fichier excel qui apparait dans la page one note ?
What do you think of DeepNotes?
Thanks for this Andy. Unfortunately there's an issue in this respect in terms of cross-device usage for the same excel spreadsheet. From briefly playing with this, as a temp file will be saved on your computer you can't access that same file from as smoothly from the OneNote section on another device (e.g. mobile or tablet).
Is there any way to insert the spreadsheet, and when opening it from OneNote, have it open the master/original document - this would easily resolve the issue when accessing/viewing/editing the spreadsheet from multiple devices.
Hi Andy,
Is there a way to choose what cells are shown in the embedded image of the spreadsheet within OneNote? It automatically shows the 7 or so columns and maybe the first 100 rows. What if I want the embedded image to only show 3 columns and 15 rows? Or 20 columns and 3 rows? When clicking "Select what to display" it only allows you to choose different sheets. Hoping there's a way to choose what is displayed in the embedded image...
Is the only workaround creating a table out of the data and selecting the table as what is displayed? What if you don't want the whole table displayed in the embedded image?
How do you add the spreadsheet in OneNote from your OneDrive so that as you are working on the Spreadsheet it autosave in OneNote?
I have an embedded spreadsheet in OneNote. Some of the cells have hyperlinks. They do not fire in the embedded copy, but they do in the Excel file. Is there any way to make this work? It appears to be view only.
Where is the spreadsheet saved when you convert table in OneNote to Excel spreadsheet?
Functionality doesn't seem to exist in Microsoft @OneNote for Mac? Wonder why.
I insert an existing spreadsheet but only the first page inserts. What do I need to do to insert the entire spreadsheet?
What version of OneNote are you using? My version doesn't have this functionality.
I'm using the latest OneNote app for Windows which can be downloaded here: www.onenote.com/download
Is it available for MacOs?
Why u stopped using Obsidian!
Hi - I continue to use Obsidian for specific research purposes. However, I don't use it for general note-taking or as a second brain.
@@AndyPark365 thanks for your reply I actually have a question for you regarding one note as when I make a sub group and open it in the mobile application you can't squeeze this subgroups and it's keep all the time open
🛑🛑🛑🛑 WARNING 🛑🛑🛑🛑🛑
First thing you should do is warn them that vba code WILL NOT RUN if the spreadsheet is run from onenote. I have been working for days changing security and macro settings and the code will not run.
🛑🛑🛑🛑