A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi,
I understand how frustrating it is to reopen the workbook just to keep editing. When this happens, does Excel close on its own, or does the workbook stay open but stop accepting edits until you close it? When you reopen it, are your latest changes still there?
If Excel is still responding, use Ctrl+S to save the open workbook before closing it. If the file is stored in OneDrive or SharePoint Online and AutoSave is on, Excel saves changes as you work. If your latest edit has already been saved, closing without a save prompt can be normal. That would explain the missing prompt, but I’d still want to check why editing stops. For your reference: Save your workbook | Microsoft Support
To check the prompt without risking your work, open a new blank workbook, type a word in a cell, and press Enter. Then click Close without saving the workbook. Excel should ask whether you want to save it. Please let me know whether that prompt appears and whether you’ve had trouble editing more than one workbook.
If Excel closes on its own and your latest edits are missing, reopen Excel and look for the Document Recovery pane. If it lists a copy of your workbook, open it and check the contents before saving it. The copy may only include changes up to the last save or recovery point.
Microsoft’s recovery guide: Recover your Microsoft 365 files | Microsoft Support