Offline mode not working in Google Sheets
The offline edits did not sync. Recover them from the offline copy in D1:E4 by updating B2:B4 to the matching Offline status values. Do not change the task names or the offline copy.
Verified by JosephineAbout 75 secondsThe offline edits did not sync. Recover them from the offline copy in D1:E4 by updating B2:B4 to the matching Offline status values. Do not change the task names or the offline copy.
Step-by-step
Select the targetThe offline edits did not sync.
Apply the changeRecover them from the offline copy in D1:E4 by updating B2:B4 to the matching Offline status values.
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 online statuses are restored to Done, Done, and In progress.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Re-select D1:E4 and repeat the final action. The online statuses are restored to Done, Done, and In progress.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Task | Online status | Offline copy | Offline status | |
| Prepare brief | Done | Prepare brief | Done | |
| Review draft | Pending | Review draft | Done | |
| Publish update | Pending | Publish update | In progress |
Video transcript
- Open the prepared Offline recovery spreadsheet.
- Select the target. The offline edits did not sync.
- Apply the change. Recover them from the offline copy in D1:E4 by updating B2:B4 to the matching Offline status values.
- The online statuses are restored to Done, Done, and In progress.