1. Make sure your spreadsheets are saved in a format that OneNote supports, such as .xlsx, .xls, .csv and others.

2. Check the Insert section of your OneNote ribbon and verify that ‘Link and Edit’ option is selected.

3. Recheck your file name for incorrect or sensitive characters.4. Ensure any security software installed is allowing OneNote to sync with your spreadsheets and files properly.

5. After the changes are made, re insert the spreadsheet into your notebook.