Onedrive LOSES my data!

Your Excel file changes in OneDrive for Business likely weren't fully synced or were overwritten due to a sync issue, crash, or conflict, even if it showed "saved." This is a common frustration with cloud-synced Office files, but recovery is often possible through built-in version history and recycle bins.

Check Version History First

Open the Excel file in the OneDrive web app (onedrive.live.com) or desktop Excel. Go to File > Info > Version History to see autosaved or previous versions—restore the one with your stock entries if available. This captures changes even if sync failed locally.​​

Inspect Recycle Bin

Log into OneDrive for Business online. Click Recycle Bin in the left pane; check both first-stage (user-accessible) and second-stage (admin-only, via site settings) for the file or prior versions—items stay up to 93 days. Select and click Restore to recover.​

Excel AutoRecover and Local Temps

In Excel, check File > Info > Manage Workbook > Recover Unsaved Workbooks. Also search your local PC for temp files like *.xlb or ~$filename.xlsx in %appdata%\Microsoft\Excel. These might hold unsynced edits from your session.

Prevention for next time…

• Always verify AutoSave is ON (toggle in top-left of Excel window when file is stored in OneDrive/SharePoint)
• Close files completely between editing sessions—don't just minimize Excel
• Check version history periodically to confirm your changes persisted

Your data almost certainly still exists in OneDrive's version history. Start with Step 1 above—95% of "lost" OneDrive files are recovered this way within minutes. If you hit a wall, contact your organization's IT support—they can often restore versions beyond what's visible to end users.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.