Fix OneNote Creating a Numbered Copy When Editing an Embedded Excel File
Question details
The user wants to stop OneNote from creating a numbered temporary copy when editing an embedded Excel file so that edits sync correctly to the original OneDrive file.
- Product
- Microsoft OneNote / Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is attempting to edit an Excel workbook that has been inserted or embedded into a OneNote page.
- Observed behavior
- Instead of updating the original OneDrive file, OneNote opens a numbered copy. Edits made on mobile devices create additional temporary copies, leading to version confusion.
Ensure you have access to the original Excel file in your OneDrive and save any pending changes from the temporary copies to your local drive before proceeding to prevent data loss.
Insert a Direct OneDrive Link Instead of Embedding the File
Prevent file duplication by inserting a direct link to the cloud file rather than embedding the spreadsheet into OneNote as an attachment.
When you embed a file in OneNote, it acts as a standalone attachment rather than a live mirror of your OneDrive document. Using a link forces your device to open the master file.
Open your OneDrive folder or log into OneDrive via your web browser to find the original Excel workbook.
Right-click the Excel file and select 'Share' or 'Copy link' to generate a direct URL.
Open your OneNote page, paste the copied link, and use this link whenever you need to edit the spreadsheet to ensure all changes sync to the original file.
Edit the Source Workbook Directly from OneDrive
Bypass OneNote embedding entirely when making extensive data entries or edits to your spreadsheets.
Submit Feedback via the OneNote Community
Report this duplicate file behavior to Microsoft's development team so they can investigate the synchronization bug.
Try WPS Office for Seamless Spreadsheet Management
If you are frustrated by temporary file copies and syncing issues in Microsoft Office, try WPS Office. It provides a lightweight, unified workspace for documents, spreadsheets, and presentations with reliable cloud syncing.
- 1. Download WPS Office: Visit the official WPS website to download and install the free suite.
- 2. Sign in to WPS Cloud: Launch the application and sign in to activate secure, automated cloud saving.
- 3. Edit your spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet and enjoy smooth editing without version conflicts.
Frequently Asked Questions
Where are the numbered copies of my embedded Excel files saved?
When OneNote creates a numbered copy, it is usually stored in a hidden temporary cache folder on your local drive (such as the AppData folder in Windows) rather than updating your original OneDrive directory.
Can I merge the changes from the temporary copy back to the original?
Yes, but it requires manual intervention. You must open the numbered copy, use 'Save As' to export it as a new file, and replace the original Excel file in your OneDrive, or manually copy and paste the updated data into the original workbook.
Why does OneNote mobile create additional temporary copies?
Mobile operating systems handle file attachments strictly for security and performance. Editing an embedded file on a mobile device triggers the OS to download the file to a temporary app cache, creating an entirely new, isolated version separate from your desktop copy.
Will embedding an Excel file in OneNote ever automatically update the original?
Currently, embedding an Excel file in OneNote treats it as a static attachment or a separate instance. To ensure real-time updates to your original cloud file, inserting a direct OneDrive link is the recommended workaround.
