In Excel for Windows on Microsoft 365, a dialog box may appear that notifies you of the most recent changes to your workbook that haven’t yet been saved 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, some changes aren’t shown, 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 column or row that was removed.
Note: You and other users must be using Microsoft 365 to make sure all changes are saved and tracked.
View older changes
The Unsaved Changes pane only shows changes that haven’t been uploaded to the cloud. To view older changes:
-
Made by you and others that are saved to the cloud, use the Show Changes command on the Review tab.
-
Over a longer period of time, select File > Info > Version History, and then select a version to preview it.
The Unsaved Changes pane is empty, but I know that I made changes
Certain actions may force Excel to clear the Unsaved Changes pane. You may see an empty pane if you have:
-
Used an Excel feature that’s not 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 can happen if the values were edited 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 are saved to the cloud
There is a possibility that some changes were saved to the cloud, but Excel didn’t receive confirmation that the change was saved, so it’s still displayed in the Unsaved Changes pane.
I only see changes made by me in the Unsaved Changes pane
The Unsaved Changes pane only shows your changes that you tried to save or have discarded. However, other users may still have unsaved changes.
See Also
Best Practices for Coauthoring in Excel