I am moving my Excel table on my current projects to OneNote due to the shared access capabilities. I have migrated all of my data from Excel to OneNote. The only problem with OneNote is that there is no facility for me to filter tables according depending on the data highlighted in a cell.
Is there any way I can filter a table in OneNote? Or should I just embed that part of the table as a Excel sheet? (However that brings up the problems with contention I was trying to avoid.)
Best Answer
OneNote doesn't support table filtering
OneNote is a tool focus on note-taking. It does not support advanced data manipulation features such as most of what you find in Excel, including table filtering. If you require this feature then you should use Excel.
But Office 365 Excel supports simultaneous editors!
If you and all of the other potential editors of your Excel workbook have Office 365 accounts you can edit the workbook simultaneously. Simply save the Excel workbook to either OneDrive or a SharePoint library and save a link to it in your OneNote notebook. Then anyone with an Office 365 account will be able to open and edit it at the same time other users are in the workbook.
More information
Collaborate on Excel workbooks at the same time with co-authoring
Work together on Office documents in OneDrive