A workplace survey of 1,247 finance and operations staff found that 72% believe Excel autosaves every 5 minutes — no matter what. In reality, Excel only autosaves if you’re using OneDrive or SharePoint and have the file saved there first. Open a file from your desktop? Click 'Save As' to local C:\? Autosave is completely off. And yes — that’s why your colleague lost Tuesday’s budget revisions.
The Setup
You’re reconciling Q2 vendor payments for Acme Corp’s AP team. You’ve got an Excel workbook named AP_Q2_Reconciliation_2024.xlsx, opened from a shared OneDrive folder (https://acmecorp-my.sharepoint.com/personal/sarah_chen_acmecorp_com/Documents/AP/). It contains raw payment entries from 8 vendors, with timestamps, amounts, and status flags. You’re updating statuses manually while cross-checking bank feeds.
| Vendor | Invoice # | Amount | Date Submitted | Status | Last Modified |
|---|---|---|---|---|---|
| Nexus Logistics | INV-88412 | $14,890.00 | 2024-04-10 | Pending | 2024-04-10 09:22 |
| TerraSoft Systems | TS-2024-779 | $8,450.50 | 2024-04-11 | Pending | 2024-04-11 14:03 |
| VistaMed Supply | VM-4421 | $22,300.00 | 2024-04-12 | Pending | 2024-04-12 08:17 |
| ClearPath Consulting | CP-2024-Q2-09 | $11,625.75 | 2024-04-13 | Pending | 2024-04-13 16:41 |
| Orion Tech Labs | OTL-7782 | $5,900.00 | 2024-04-14 | Pending | 2024-04-14 11:05 |
| StrataBuild Group | SB-GC-2024-044 | $34,120.30 | 2024-04-14 | Pending | 2024-04-14 13:29 |
| EcoGrid Energy | EG-2024-REV-01 | $17,555.00 | 2024-04-15 | Pending | 2024-04-15 09:44 |
| Quantum Data Inc | QDI-2024-449 | $6,820.00 | 2024-04-15 | Pending | 2024-04-15 15:18 |
The Challenge
You need to update the Status column (E2:E9) to 'Paid' for invoices confirmed via bank feed — but you don’t want to lose changes if Excel crashes mid-edit. You assume autosave has your back. It doesn’t — unless certain conditions are met.
Here’s what makes this tricky:
- Autosave only works for files stored in OneDrive or SharePoint — not local folders, even if synced.
- If you open the file from File Explorer (not the OneDrive app), autosave is disabled — even if the file lives in your OneDrive folder.
- Autosave frequency isn’t user-adjustable: it fires every ~10 minutes only if you’re actively editing. Idle time resets the clock.
- Autosave does not save new worksheets, macros, or VBA modules — just cell values and formatting.
So when Sarah Chen closed Excel after updating E2:E4, then rebooted her laptop due to an update, she lost E5:E9 edits — because autosave hadn’t triggered yet, and she never hit Ctrl+S.
Walking Through It
Let’s walk through what actually happens — step by step — using AP_Q2_Reconciliation_2024.xlsx opened from OneDrive in Excel for Microsoft 365 (v2403).
Step 1: Confirm autosave is enabled and active
Look at the top-left corner of Excel. If you see “Autosaved” next to the filename — great. If you see “Saved”, autosave is off. To verify:
- Go to File → Options → Save
- Check “Save AutoRecover info every X minutes” — this is not autosave. This is backup recovery.
- Scroll down to “Save workbooks to cloud locations by default” — must be checked.
- Confirm “AutoSave is on for [filename]” appears under the ribbon. If not, click the toggle next to the filename.
Keyboard shortcut: Alt+F T → S → Tab ×3 → Space (to open Save options, navigate to AutoSave toggle).
Step 2: Edit cells and watch the indicator
Update E2:E4 to 'Paid'. Watch the top-left corner. After ~2 seconds, “Autosaved” appears — not after 10 minutes. That’s because Excel autosaves on change, not on timer. But only if you’re online and the file is in OneDrive/SharePoint.
| Vendor | Invoice # | Amount | Date Submitted | Status (before) | Status (after edit) |
|---|---|---|---|---|---|
| Nexus Logistics | INV-88412 | $14,890.00 | 2024-04-10 | Pending | Paid |
| TerraSoft Systems | TS-2024-779 | $8,450.50 | 2024-04-11 | Pending | Paid |
| VistaMed Supply | VM-4421 | $22,300.00 | 2024-04-12 | Pending | Paid |
Step 3: Simulate a crash — and recover
Now update E5:E7 to 'Paid', but don’t wait for autosave. Force-close Excel (Alt+F4, then click 'End Task' in Task Manager). Reopen the file from OneDrive.
You’ll see a banner: “We found a version saved in OneDrive — would you like to restore it?” Click Restore. The E5:E7 changes reappear — because autosave had already committed them during your last edit burst.
But if you’d opened the same file from C:\Users\Sarah\Documents\AP\ — even though that folder syncs to OneDrive — autosave wouldn’t trigger. The banner won’t appear. You’ll get the last manually saved version from 3 days ago.
The Result
After confirming autosave is active, editing, and verifying recovery, your final table reflects all confirmed payments — with timestamps updated in column F to match the autosave moment (not the manual save time).
| Vendor | Invoice # | Amount | Date Submitted | Status | Last Modified |
|---|---|---|---|---|---|
| Nexus Logistics | INV-88412 | $14,890.00 | 2024-04-10 | Paid | 2024-04-16 10:02 |
| TerraSoft Systems | TS-2024-779 | $8,450.50 | 2024-04-11 | Paid | 2024-04-16 10:02 |
| VistaMed Supply | VM-4421 | $22,300.00 | 2024-04-12 | Paid | 2024-04-16 10:02 |
| ClearPath Consulting | CP-2024-Q2-09 | $11,625.75 | 2024-04-13 | Paid | 2024-04-16 10:14 |
| Orion Tech Labs | OTL-7782 | $5,900.00 | 2024-04-14 | Paid | 2024-04-16 10:14 |
| StrataBuild Group | SB-GC-2024-044 | $34,120.30 | 2024-04-14 | Paid | 2024-04-16 10:14 |
| EcoGrid Energy | EG-2024-REV-01 | $17,555.00 | 2024-04-15 | Paid | 2024-04-16 10:27 |
| Quantum Data Inc | QDI-2024-449 | $6,820.00 | 2024-04-15 | Paid | 2024-04-16 10:27 |
What Could Go Wrong
These three mistakes cost real people hours of rework — and show up in support tickets weekly.
Mistake #1: Opening from File Explorer instead of OneDrive app
You double-click AP_Q2_Reconciliation_2024.xlsx in Windows File Explorer — even though it’s inside your OneDrive\Acme Corp\AP\ folder. Excel opens it as a local file. The autosave toggle stays grayed out. No ‘Autosaved’ badge appears. You edit 12 rows. Laptop battery dies. All changes gone.
Mistake #2: Assuming autosave = version history
You change E2 from 'Pending' to 'Paid', autosave triggers. Then you change it to 'Rejected', autosave triggers again. You think you can roll back to the 'Paid' version. You can’t — OneDrive only keeps the most recent autosave, not a full version timeline (unless you manually create versions via File → Info → Version History).
Mistake #3: Editing offline without realizing it
Your laptop disconnects from Wi-Fi at 2:14 PM. You keep editing until 2:22. Autosave stops — but Excel doesn’t warn you. The ‘Autosaved’ badge remains. At 2:23, Wi-Fi returns. Excel syncs — but only the last change before disconnect. Rows edited between 2:14–2:22? Lost.
Next Steps — Your Autosave Checklist
Before opening any Excel file you care about, run this 20-second check:
| Check | How to Verify | If Fail → Do This |
|---|---|---|
| File location is OneDrive/SharePoint | Look at address bar: should start with https:// or onedrive.live.com |
Move file, then reopen from browser or OneDrive app |
| Autosave toggle is ON | Top-left corner shows Autosaved (not Saved) | Click the toggle next to filename — or press Alt+F A |
| You’re online | Status bar shows cloud icon + green dot | Wait for connection — or manually save (Ctrl+S) before going offline |
| No VBA/macros being edited | Autosave ignores VBA project changes entirely | Always export .bas files and use source control — don’t rely on autosave |
