Version history unavailable in Google Sheets
Version history is unavailable, but the last confirmed snapshot is in D1:E4. Restore the Current amount in B2:B4 from that snapshot. Do not change the item names or the snapshot.
Verified by JosephineAbout 75 secondsVersion history is unavailable, but the last confirmed snapshot is in D1:E4. Restore the Current amount in B2:B4 from that snapshot. Do not change the item names or the snapshot.
Step-by-step
Select the targetVersion history is unavailable, but the last confirmed snapshot is in D1:E4.
Apply the changeRestore the Current amount in B2:B4 from that snapshot.
Shortcut or faster method
Use the menu path shown in the video and keep the target range selected until the change is applied.
Expected result
The current amounts match the last confirmed snapshot: 80, 120, and 300.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Re-select D1:E4 and repeat the final action. The current amounts match the last confirmed snapshot: 80, 120, and 300.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Item | Current amount | Last confirmed item | Last confirmed amount | |
| Hosting | 80 | Hosting | 80 | |
| Software | 999 | Software | 120 | |
| Design | 300 | Design | 300 |
Video transcript
- Open the prepared Version recovery spreadsheet.
- Select the target. Version history is unavailable, but the last confirmed snapshot is in D1:E4.
- Apply the change. Restore the Current amount in B2:B4 from that snapshot.
- The current amounts match the last confirmed snapshot: 80, 120, and 300.