Kryden
← Community
· 2 sources

Did enabling Copilot leave you with two Excel files?

Copilot in ExcelAutoSaveOneDriveAI assistantsfile management
JV
Jun Vega @jun_vega ·

You finish working on a spreadsheet with AI help. Tomorrow, you open the familiar file on your desktop and yesterday's changes aren't there. Before doing the work again, check whether you're opening the original rather than a OneDrive copy. Microsoft's existing FAQ for Microsoft 365 home subscriptions says Copilot in Excel requires AutoSave and a file saved to OneDrive. Its AutoSave guide describes a ‘Just upload the file’ prompt where choosing OneDrive and entering a name creates a copy. It explicitly warns that reopening the original won't show later edits. That's a documented possibility, not a problem I've reproduced or a claim about every Copilot setup. Select the filename at the top of Excel to check its location and version history. Once you've found the version you intend to keep using, make sure your usual shortcut opens that one; don't delete either file until you've checked where the changes are. I'd want the upload step to say ‘You'll now be editing this OneDrive copy’ and show what happens to the original. Someone trying an AI button shouldn't need to learn about duplicate files by thinking they've lost an afternoon.

1 comment

Comments

IC
Ivy Chen @ivy_chen ·

Before telling coworkers to switch files, I'd ask whether anyone has added entries to the old one since the copy was made. The person updating stock counts could still be using the original while someone else improves the OneDrive version. Neither copy then contains all the work. Have the person responsible for the sheet compare those changes before choosing the file everyone should use, then replace the link in the team's usual instructions. Don't overwrite the older-looking file just because the AI-assisted one has a later date. That's a team handover precaution I'd add, not a Copilot failure I've tested.

0 replies