Autosave saving Copies of my Files rather than the orifinal files?

Question

My system sometimes opens a Microsoft Office file without the Autosave feature on and then when i want to save the file, it saves it to my one drive as a numbered copy and not as the original. When I go back to open the file as it exists on my desktop, that file does not have my changes saved.. How can i prevent this?

Answer 1

Hello, I'm Quinn and here to help!

Numbered copies appear because Office is trying to save a file to OneDrive that already exists locally, and it won’t overwrite automatically without your confirmation. To prevent this, follow these steps:

1. Open File > Options > Save in Word/Excel.
2. Check:
   • Save to Computer by default > ON
   • AutoSave files stored in the Cloud by default on Word/Excel > OFF (optional if you only want local files autosaved manually)
3. Now, pressing Ctrl + S will overwrite your original desktop file instead of creating a numbered copy in OneDrive.

Now, pressing Ctrl + S will overwrite your original desktop file instead of creating a numbered copy in OneDrive. For OneDrive, you only need to make sure it syncs properly:

1. On your taskbar, click the OneDrive cloud icon (bottom-right corner, near the clock)
2. Click the gear icon (Settings) in the top-right of the OneDrive pop-up
3. Select Settings from the dropdown
4. Go to the Sync and Backup tab
5. Click Manage Backup
6. Toggle ON the folders you want OneDrive to back up (Desktop, Documents, Pictures)
7. Click Start Backup

Answer 2

The behavior occurs when Office opens the file as a local file (AutoSave off) instead of as a cloud file, so saving creates a new copy in OneDrive instead of updating the original.

To prevent this:

1. Make sure the file is actually stored in OneDrive/SharePoint Online
   AutoSave is only enabled when the file is saved in OneDrive, OneDrive for Business, or SharePoint Online. If the file is on the desktop, a local drive (like C:\), a file server, or another cloud service, AutoSave will be off and saving to OneDrive will create a separate copy. Move or save the file directly into a OneDrive folder first, then open it from there so AutoSave can stay on.
2. Check why AutoSave is disabled for that file
   Even in OneDrive, AutoSave can be disabled for several reasons:
   • The file is in an older format such as .doc, .xls, or .ppt. Save it as .docx, .xlsx, or .pptx.
   • The file is in a local OneDrive folder but OneDrive sync is paused. Resume OneDrive sync.
   • The file is being synced by an older OneDrive sync app. Update OneDrive.
   • The file is embedded inside another Office file.
   • For PowerPoint, the presentation is in slide show mode.
   Fixing these conditions will allow AutoSave to stay on and update the original cloud file instead of creating numbered copies.
3. Be aware of the recent OneDrive/Office issue (if applicable)
   There was a temporary issue where OneDrive files opened as if they were local files, with AutoSave disabled, and turning on AutoSave prompted to upload to OneDrive again. This could cause the behavior described. This issue was fixed in an April 2024 update. If this matches the timing and setup:
   • Close all Office apps (including Outlook and OneNote).
   • Reopen the file from OneDrive and confirm AutoSave is on and the title bar shows the OneDrive location.
4. Use “Save a Copy” when intentionally creating a new version
   If the goal is to keep the original unchanged and work on a separate version, use File > Save a Copy immediately after opening the original. This ensures AutoSave applies to the copy and not the original, avoiding confusion about which file is being updated.

Once files are consistently opened from OneDrive/SharePoint with AutoSave enabled, edits will be saved to the original online file, and numbered copies will no longer be created unexpectedly.

---

References:

• What is AutoSave?
• OneDrive files incorrectly opened as local files without AutoSave