In Excel for Windows on Microsoft 365, a dialog box might appear that notifies you of recent workbook changes that haven't yet been uploaded to the cloud. As a result, you can see edits for cells, ranges, sheets, or the entire workbook that are waiting to be uploaded to the cloud in the Unsaved Changes pane.
The following sections provide more information.
I made a change, but I don't see it in the Unsaved Changes pane
The Unsaved Changes pane shows unsaved changes made to cell values and formulas. This includes operations like moving, sorting, inserting, and deleting cells or ranges. However, it doesn't show some changes, such as changes to:
- Chart, shape, and other object edits
- PivotTable operations
- Formatting
- Hiding of cells or ranges
- Filtering
- A deleted location, such as a cell in a deleted row or column.
Note
You and other users must be using Microsoft 365 to ensure that all changes are saved and tracked.
View older changes
The Unsaved Changes pane only shows changes that weren't uploaded to the cloud. To view older changes:
- Use the Show Changes command on the Review tab to view changes made by you and others that are saved to the cloud.
- Select File > Info > Version History to view changes over a longer period of time, and then select a version to preview it.
The Unsaved Changes pane is empty, but I know that I made changes
Certain actions might force Excel to clear the Unsaved Changes pane. You might see an empty pane if you:
- Used an Excel feature that isn't supported in Excel co-authoring. For more information, see Troubleshoot co-authoring in Office.
- Continued editing without first saving a copy or discarding your unsaved changes.
Some of my changes are missing previous values in the Unsaved Changes pane
Sometimes, the Unsaved Changes pane doesn't show the previous values of certain edits. This condition can happen if you edited the values through code, for example by changing a value through Visual Basic for Applications (VBA) or by using an Excel Add-in.
Some changes still appear in the Unsaved Changes pane, but they're saved to the cloud
It's possible that some changes were saved to the cloud, but Excel didn't receive confirmation that the change was saved, so it still displays in the Unsaved Changes pane.
I only see changes made by me in the Unsaved Changes pane
The Unsaved Changes pane only shows your own unsaved or discarded changes. However, other users might still have unsaved changes.
See also
Best Practices for Coauthoring in Excel