Fix OneNote Opening a Numbered Copy of Excel Files
Question details
The user needs to know how to edit an original OneDrive Excel file through OneNote without the application opening and saving changes to a temporary, numbered duplicate.
- Product
- Microsoft OneNote and Excel
- Device & OS
- not provided
- Scenario
- Editing an Excel spreadsheet that has been inserted into a OneNote page.
- Observed behavior
- OneNote opens an extracted temporary copy with a numbered or alphanumeric filename. Saving changes updates the embedded copy within OneNote rather than the original file stored in OneDrive.
Understand that inserting a file directly into OneNote as an attachment creates an independent, embedded copy. Check your OneDrive to locate your original Excel spreadsheet before making further edits to avoid losing your changes in a temporary folder.
Use a OneDrive Link Instead of Embedding the File
The best way to maintain a live connection to your original Excel file is to insert a web link rather than embedding the file directly onto the page.
When a file is inserted as an attachment, OneNote extracts a temporary copy to your local AppData folder so Excel can open it. Saving it only updates the embedded OneNote copy. Linking the file ensures you are opening the master file in OneDrive.
Ensure your master Excel spreadsheet is saved and fully synced in your OneDrive folder.
Right-click the Excel file inside your OneDrive directory (or OneDrive web portal) and select 'Share' or 'Copy link'.
Open your OneNote page, right-click, and paste the link. Clicking this link will now open the live document directly from OneDrive.
Open the Spreadsheet Directly from OneDrive
Bypass OneNote entirely when you need to make permanent changes to the master spreadsheet.
Clear the OneNote Cache to Resolve Glitches
If OneNote is failing to sync properly or producing excessive temporary files unexpectedly, clearing the local cache can help resolve conflicts.
Try WPS Office for Seamless File Management
Since the temporary file generation behavior belongs to Microsoft Office's fundamental architecture for embedded files, it cannot be 'fixed' beyond changing how you link files. If you find this file management system confusing, consider switching to WPS Office. It provides a straightforward, unified workspace for documents and spreadsheets without the hassle of complex embedding quirks.
- 1. Download the Installer: Visit the official WPS website and download the free installer for your operating system.
- 2. Install WPS Office: Run the installer and follow the on-screen prompts to set up the software.
- 3. Open Your Spreadsheets: Launch WPS Office and open your existing .xlsx files directly from your cloud or local drive.
Frequently Asked Questions
Why does OneNote change the name of my Excel file to random numbers?
When you embed a file as an attachment, OneNote extracts it to a temporary local folder so your computer's default application can open it. It assigns an alphanumeric or numbered name to prevent overwriting other temporary files in that directory.
Does saving the numbered copy update my original OneDrive file?
No. Saving the temporary numbered file only updates the embedded copy stored inside your OneNote notebook. Your original file in OneDrive remains entirely untouched.
How can I edit the live Excel file directly from OneNote?
You cannot do this with an embedded file attachment. Instead, you must insert a direct URL or OneDrive sharing link onto your OneNote page. Clicking the link will then open the live cloud file.
What happens if I click 'Save a Copy' on my mobile device?
Mobile versions of OneNote extract the file to local temporary storage. Clicking 'Save a Copy' will prompt you to save it as a brand new standalone file on your device or cloud drive rather than updating the embedded notebook version.
